Fast-Track Base Programming: The Language of SAS

An Introduction to the language of SAS

• Program Components
• What are Datasets
• The LIBNAME Statement

Background Concepts

• Syntax Rules
• Datasets
• Naming Conventions
• Dates and Times
• Missing Values

Building Data Steps

• The DATA Statement
• The SET Statement
• Creating New Variables
• Data Step Processing

Introducing Functions

• The SUM Function
• The MEAN Function
• Date Functions
• Character Functions

Selecting Variables and Observations

• KEEPing and DROPing Variables
• The IF Statement
• The WHERE Statement

IF - THEN - ELSE Processing

• IF-THEN-ELSE Syntax
• DO-END Syntax
• The LENGTH Statement
• The OUTPUT Statement
• The DELETE Statement

Sorting Data with PROC SORT

• PROC SORT Syntax
• Creating an Output Dataset
• Removing Duplicate Data

Combining Data

• Combining Data Vertically
• Combining Data Horizontally

Reading Raw Data

• The INFILE Statement
• The INPUT Statement
• Reading Non-Standard Data
• Subsetting Raw Data

Labels and Formats

• Labels
• Supplied Formats
• User-Defined Formats

Frequency Counts with PROC FREQ

• One-Way Frequency Tables
• Two-Way Frequency Tables
• Creating Output Datasets

Summary Statistics with PROC MEANS

• The VAR Statement
• The CLASS Statement
• PROC MEANS Options

The Output Delivery System

• ODS Destinations
• Creating HTML Files
• Creating Datasets

List Reports with PROC PRINT

• PROC PRINT Syntax and Statements
• PROC PRINT Options
• TITLES and FOOTNOTES

Summary Tables with PROC TABULATE

• The TABLE Statement
• One, Two and Three Dimensional Tables
• Creating Multiple Tables

The OUTPUT Statement

• The OUTPUT Statement
• Outputting to Multiple Datasets
• Selecting Observations
• Selecting Variables

Summarising Observations

• The RETAIN Statement
• The SUM Statement
• BY-GROUP Processing

Manipulating Data using Functions

• Transforming Character Variables
• Transforming Numeric Variables
• Transforming Date Variables
• Changing Variable Type

Debug programs using PUT Statements

• The PUT Statement
• The PUTLOG Statement

Iterative Processing

• DO Loops
• DO WHILE and DO UNTIL Loops

Array Processing

• Defining an ARRAY
• Using an ARRAY to Create Variables
• ARRAYs with Initial Values
• The TEMPORARY Keyword
• Using an ARRAY with Existing Variables
• Using an ARRAY to Transpose Data

Reading Raw Data

• The INFILE and INPUT Statements
• Fixed-Width Column Data
• Data Errors
• Formatted Data
• INFORMATS
• Detecting Errors
• The DATALINES Statement
• The Single Trailing @
• The Double Trailing @
• Delimited Data
• The DSD Option