Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

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

  • Tuition USD $2,175 GSA  $1,768.26
  • Reviews star_rate star_rate star_rate star_rate star_half 2019 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® Programming 1: 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® Programming 1: 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

When does class start/end?

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

Does the course schedule include a Lunchbreak?

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.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Communications were good and team was available to answer questions at any time.

I thought this was a really cool experience. First time getting so much information crammed into two days.

Great Class that will help as the state moves forward with the Cloud solution.

The course presentation and the material that accompanies the course were both very good. I learned many new important topics that can possibly be applied at my place of work.

The course was conducted in a methodical and in a timely manner. Very professional.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

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