search: Search support.sas.com KNOWLEDGE BASE     System Requirements     Install Center     Product Documentation     Papers     Samples & SAS Notes     Focus Areas SUPPORT     License Assistance     Administrator Services     Downloads & Hot Fixes LEARNING CENTER     Bookstore     Training     Certification     SAS Learning Edition     Higher Education Resources     SAS OnDemand For Academics COMMUNITY     User Groups     Events     E-Newsletters

• Print |
• E-mail  |
• Bookmark

This course is for those who need to learn SAS DATA step programming techniques for processing, controlling, and manipulating 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.

Learn how to

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

Who should attend

SAS programmers and business analysts

Approximate duration:  24 hours

License period:  365 days

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

• create and access files in your operating environment
• explain the structure of a SAS program
• explore the structure and contents of a SAS data set
• distinguish between syntax and data errors
• debug a SAS program
• create a SAS data set from a fixed-format external file
• subset the rows and columns of a SAS data set
• create derived variables
• write conditional logic statements
• read and write SAS date values
• access SAS data libraries
• sort a SAS data set
• read one or more SAS data sets using a SET statement
• perform a simple merge using a MERGE statement
• create detail and summary reports from a SAS data set
• place titles and footnotes on reports.

Introduction

• review of SAS basics
• review of DATA step processing
• review of displaying SAS data sets
• working with existing SAS data sets

Controlling Input and Output

• outputting multiple observations
• writing to multiple SAS data sets
• selecting variables and observations
• writing to external files

Summarizing Data

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

Reading and Writing Different Types of Data

• reading delimited raw data files
• controlling when a record loads
• reading hierarchical raw data files

Data Transformations

• manipulating character variables
• manipulating numeric variables
• manipulating numeric variables based on dates
• converting variable type

Processing Data Iteratively

• performing DO loop processing
• performing SAS array processing

Combining SAS Data Sets

• match-merging two or more SAS data sets
• performing simple joins using the SQL procedure (self-study)

Learning More

• identifying additional resources

Students have unlimited 24/7 access to the interactive multimedia course on the Web for one year. The course requires only a standard Web browser and a free Flash plug-in. The course includes data that can be downloaded, printable lesson summaries, a Quick Reference Guide, practices and solutions, step-by-step demonstrations, and a Certificate of Completion.

This course addresses Base SAS. This course is appropriate for students who are using SAS Version 8 or SAS 9 software.

You should

• use Internet Explorer 6.0 or later or Firefox 1.5 or later, with JavaScript and cookies enabled
• have the latest version of Macromedia Flash Player installed
• have base SAS software visible on the same machine that you are taking the training on so that you can practice your new skills in your own SAS environment.

.

Share Your Thoughts
If you have suggestions for this course, let us know by adding to our Interest List.



This page was created using SAS software.