SAS Programming Review (Modules 1-7)

A SAS Program consists of a series of steps. Each Step Performs a specific Task

Data Steps read, process, or create data

Proc Steps report, manage, and analyze data

Steps usually end with run; Proc Steps may end with quit

All SAS statements end with a semi colon;

Global Statements are outside of steps and do not need a run; statement

Comments in SAS are between /* and */

SAS Table - has defined rows and columns

A row is called an observation

A column is called a variable

3 Attributes of a column: Name, Type, Length

A libname statement creates the library

OPTIONS VALIDVARNAME=V7 forces tables and column names to follow SAS naming convention

To import using the excel engine: libname xlclass xlsx "s:/workshop/data/class.xlsx";

To read a specific worksheet refer to nameofdatafile.nameof worksheet

To import an unstructured data file use a PROC IMPORT and use the DBMS= to list the file type you are importing.

Proc Print - by default lists all rows and columns

Proc Means- generates summary stats for each numeric column

Proc Freq- creates a frequency column for each column in the input column

Proc Univariate-generates summary stats for stats related to distribution and extreme values.