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