SAS for Programmers

Objectives
On successful completion of this course, attendees will be able to:

• describe the features and functions of SAS
• develop sophisticated data manipulation and reporting applications
• describe and use a core set of Base SAS data statements and procedures
• generate and modify simple SAS applications.

Who Should Attend
This course is appropriate for all application, production and technical support personnel who need an introduction to programming using Base SAS.
Prerequisites
All attendees should have at least six month''s experience of using another programming language or data manipulation and reporting utilities.
Duration
2 days
Course Code
DBS
Contents
Introduction to the SAS system
The SAS System; DATA steps; PROC steps; a SAS job.


SAS language
SAS syntax; SAS variables; SAS datasets; OPTIONS.


Creating a SAS dataset
DATA step: INFILE, INPUT, column; list and formatted input; selected informats; column and line pointers; holding input records.


Sorting and printing SAS data
PROC SORT: BY groups; PROC PRINT: BY groups; formatting options.


DATA step programming
DATA step: assignment, expressions, functions; IF subsetting; IF - THEN / ELSE: comparison and logical operators; DO / END; SELECT / WHEN / END; LINK / RETURN; GO TO.


Custom report facilities
Data step: FILE, PUT, constants; formatting SAS variables; column and line pointers; holding output records.


SAS date and time values
Date and time informats; date and time variables; date and time functions; date and time formats.


More SAS procedures
PROC CALENDAR, PROC FREQ, PROC SUMMARY.


Processing SAS datasets
Data step: SET, MERGE, UPDATE; PROC SQL.


Writing SAS data to MVS datasets
Review of MVS file organisations; data step: FILE options, S/370 formats; JCL needed.


Errors and missing values
The SAS log; syntax errors; processing errors; missing values; diagnostic aids.


Introduction to macros
Automatic variables; CALL SYMPUT; macro language; macro syntax, variables, statements; debugging macros.


Other SAS components
SAS/GRAPH; SAS/AF; SAS/FSP; SAS/ACCESS; SAS/STAT; SAS/CONNECT; SAS/CPE.