SAS Programming Fast Track - Fundamentals (FAST1)

Duration

5 days

Description

This course provides the most comprehensive way to learn to write SAS programs to accomplish basic data-processing tasks.  This course condenses the SAS Programming I and II courses, which are normally conducted over 6 days.  This course teaches the basics of programming with SAS, including structure, using basic functions and commands, merging, producing basic reports, manipulating storing and cleansing data as well as showing you how to produce results faster..

Prerequisite Skills

Before attending this course, you should have experience using computer software. Specifically, you should be able to:

• understand concepts such as file and variable
• access data files on your operating system
• understand programming logic concepts such as IF/THEN

No prior SAS experience is needed.

Course Topics

Getting Started with SAS

• overview of the SAS System
• introduction to SAS programs
• running SAS programs
• mastering fundamental concepts
• diagnosing and correcting syntax errors
• exploring the SAS environment (self-study)

Getting Familiar with SAS Data Sets

• explaining the concept of a SAS data library

Producing List Reports

• getting started with the PRINT procedure
• sequencing and grouping observations
• identifying observations (self-study)
• using special WHERE statement operators (self-study)

Enhancing Output

• customizing report appearance
• formatting data values
• creating HTML reports

Creating SAS Data Sets

• reading raw data files using column input and formatted input
• examining data errors
• assigning variable attributes
• changing variable attributes (self-study)
• reading Microsoft Excel spreadsheets (self-study)

Programming with the DATA Step

• reading SAS data sets and creating variables
• executing statements conditionally
• dropping and keeping variables (self-study)
• reading date fields from Microsoft Excel spreadsheets (self-study)

Combining SAS Data Sets

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

Producing Summary Reports

• introduction to summary reports
• generating basic summary reports
• using the REPORT procedure
• creating reports using the TABULATE procedure (self-study)

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

 

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.