Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

SAS(R) Programming 2 : Data Manipulation Techniques for FedEx Institute

  • Tuition USD $1,950
  • Reviews star_rate star_rate star_rate star_rate star_half 329 Ratings
  • Course Code FEPG2
  • Duration 3 days
  • Available Formats Classroom

This course is for those who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. The course builds on the concepts that are presented in the SAS(R) Programming I: Essentials course and is not recommended for beginning SAS software users. This course can help prepare you for the following certification exams: SAS Base Programming for SAS 9 and SAS Certified Clinical Trials Programmer Using SAS 9.

Skills Gained

  • control SAS data set input and output
  • combine SAS data sets
  • summarize, read, and write different types of data
  • perform DO loop and SAS array processing
  • transform character, numeric, and date variables.

Who Can Benefit

  • Business analysts and SAS programmers

Prerequisites

  • Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS(R) Programming I: Essentials course and used SAS for at least one month. Specifically, you should be able to
  • submit a SAS program
  • diagnose and correct syntax errors
  • examine descriptor and data portions of a SAS data set
  • access SAS data libraries
  • read and create SAS data sets
  • read Excel spreadsheets
  • read delimited raw data files
  • examine data errors when reading raw data files
  • use SAS procedures to validate data
  • clean invalid data
  • create variables
  • combine SAS data sets
  • use global statements
  • use labels and formats, including user-defined formats
  • subset observations
  • produce summary reports using the FREQ and MEANS procedures.

Course Details

Introduction

  • course logistics

Controlling Input and Output

  • writing observations explicitly
  • writing to multiple SAS data sets
  • selecting variables and observations

Summarizing Data

  • creating an accumulating total variable
  • accumulating totals for a group of data

Reading Raw Data Files

  • reading raw data files with formatted input
  • controlling when a record loads

Data Transformations

  • manipulating character values
  • manipulating numeric values
  • converting variable type

Debugging Techniques

  • using the PUTLOG statement

Processing Data Iteratively

  • DO loop processing
  • conditional DO loop processing
  • SAS array processing
  • using SAS arrays

Restructuring a Data Set

  • rotating with the DATA step

Combining SAS Data Sets

  • using data manipulation techniques with match-merging

Creating and Maintaining Permanent Formats

  • creating permanent formats

Other SAS Languages

  • an overview of other languages
  • using the SQL procedure
  • the SAS macro language

Learning More

  • SAS syntax review
  • additional techniques for raw data input
  • using the DEBUG option
  • using the TRANSPOSE procedure

Self-Study Topics

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

The course material and instructor were very good. easy to follow, lab was setup nicely and was able to complete most of the lab material.
The Koretex App is absolute garbage and very cumbersome to use on a tablet/ipad. A PDF file would be 100 times better than that atrocious app.
As a recommendation this class should be 5 days instead of 4 as some chapters had to be rushed.

Good in providing online courses and rescheduling was followed up very well, but the earbuds promised were not sent.

Instructor was engaging, very knowledgeable, and explained things clearly. Labs were helpful in getting used to the tools that were being taught. Course location (Atlanta Microtek facility) was very comfortably set up. I'd definitely recommend this to anyone learning a new skill. (I took the 3-day AWS Big Data training).

Great instruction on AWS DevOps, even added more to the presentation for better understanding. The teacher was well informed and technically savvy to assist students on the fly through hiccups.

Structured training in a great environment with knowledgeable and patient instructor

0 options found

undo
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward