Audience

This course is designed for students who have some experience with SAS and want a more in-depth understanding of the product.

Duration

3 days

Abstract

This course will cover the major facilities of the programming aspects of SAS using a lecture/workshop format. Emphasis will be on the DATA step, with a brief look at several SAS PROCs.

Objectives

• Understand SAS data structures and attributes in detail
• Understand how SAS processes your jobs from compilation through execution
• Understand and alter SAS system global options
• Alter SAS attributes as needed for correctness and efficiency
• Use SAS code for looping, branching, and logic
• Learn to read difficult and complex raw data files
• Use SAS functions for data handling and manipulation
• Read and write various date formats and perform date arithmetic
• Learn possible uses and problems with the SAS array processor
• Address storage of compiled DATA step source code
• Utilize WHERE statements to maximize coding efficiency
• Draw random samples, subset data, and use testing techniques
• Learn to merge, concatenate, subset, and interleave data
• Understand SAS VIEWS and PROC SQL
• Understand the basics of the SAS macro facility
• Develop strategies for writing good SAS programs
• Address efficiency concerns with SAS
• Know how and when COMPRESSion and INDEXing should be used on a dataset

Outline

• SAS data structures and DATA step flow
• SAS executable statements
• SAS libraries
• Advanced input features
• Data step functions
• SAS arrays
• Dates and times in SAS
• Reading SAS data sets with SET
• Merging SAS data sets
• SAS efficiencies
• Raw data and utility applications
• An introduction to SAS macros
• Using cascading style sheets
• Programming an automated table of contents