Procedures
Functions and CALL Routines
Formats and Informats
System and ODS Options
Miscellaneous
100

The procedure that adds observations from one SAS dataset to the end of another SAS dataset

What is PROC APPEND?

100

This function returns the number of words in a character string.

What is the COUNTW function?

100

This format writes numeric values with a comma separating every 3 digits and a period separating the decimal portion.

What is the COMMAw.d format?

100

This statement opens the destination to generate a specific output format.

What is ODS destination_name?

100

The max number of characters a libref can have.

What is eight?

200

This procedure lists the contents of a SAS dataset, including the number of observations and information about the variable attributes.

What is PROC CONTENTS?

200

This function extracts the date from a SAS datetime value.

What is the DATEPART function?

200

This format writes SAS date values as the name of the day of the week.

What is the DOWNAMEw. format?

200

This ODS option controls page breaks.

What is the STARTPAGE= option?
200

January 1st, 1960

What is the SAS date value of zero?

300

This procedure uses the keyword 'tables' instead of 'var' to specify the variables for analysis. 

What is PROC FREQ?

300

This routine assigns missing values to the specified character or numeric variable(s).

What is the CALL MISSING routine?

300

This informat reads and extracts the date value from different date, time, and datetime forms.

What is the ANYDTDTEw. informat?

300

This ODS statement turns off procedure titles.

What is ODS NOPROCTITLE?

300

This type of statement does not need a 'run;' at the end.

What is a global statement?

400

Datasets must be altered through this procedure before merging or joining.

What is PROC SORT?

400

This function returns the number of interval boundaries between two dates, times, or datetime values.

What is the INTCK function?

400

An example of this format being applied to a date value is MAY2012.

What is the MONYY7. format?

400

This system option specifies the rules for using/creating valid SAS variable names during the session.

What is validvarname= ?

400

Encountering one of these four statements signifies the end of a SAS program step.

What are the DATA, PROC, QUIT, and RUN statements?

500

This procedure is an alternative to reading Excel files via the 'libname' statement.

What is PROC IMPORT?

500

This function removes/replaces all occurrences of a substring in a character string.

What is the TRANWRD function?

500

SAS supplies this function to read from a character variable according to an informat.
num_var = ___ (char_var , 3.)

What is the INPUT function?

500

This system option specifies the last record in a dataset to process.

What is OBS= ?

500

These are the three main rules for naming SAS tables and variables.

Up to 32 characters; first character must be letter or underscore; no blanks or special characters (except for underscore).

M
e
n
u