SAS Programming Review (Modules 1-7)

SAS Programming Review (Modules 1-7)

Module 1

• 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 */

Multiple Choice

What does every statement in SAS end with?

• *

• /

• ;

• Any of the above

Module 2 Lesson 1

• 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

Multiple Choice

What is a row in SAS called?

• Variable

• Observation

• Reference

• Libname

Module 2 Lesson 2

• 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.

Multiple Choice

What would you use to import an unstructured data file?

• Data step

• Format statement

• PROC IMPORT

• None of the above

Module 3

• 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.