SAS Procedures
This procedure lists the contents of a SAS dataset, including the number of observations and information about the variable attributes.
What is PROC CONTENTS?
The temporary library.
What is work?
This is the engine that is specified when reading an Excel file in through a LIBNAME statement.
What is XLSX?
This is a global statement that establishes a permanent label at the top of the report for all reports created in your SAS session.
What is TITLE?
January 1st, 1960
What is the SAS date value of zero?
This procedure uses the keyword 'tables' instead of 'var' to specify the variables for analysis.
What is PROC FREQ?
This follows the LIBNAME keyword.
What is library reference or libref.
"Name of the library you want to create"
This statement within a DATA step allows you to pull in an already existing SAS data file.
What is FOOTNOTE?
This ODS statement turns off procedure titles.
What is ODS NOPROCTITLE?
Datasets must be altered through this procedure before merging or joining.
What is PROC SORT?
This is the number of characters that the name of a library is limited to.
What is eight?
This option allows you to specify the file type within a PROC IMPORT.
What is DBMS?
This statement allows to create a macro variable to change repeating values quickly in one place.
What is a %let?
This type of statement does not need a 'run;' at the end.
What is a global statement?
This procedure is an alternative to reading Excel files via the 'libname' statement.
What is PROC IMPORT?
These are restrictions to the characters used in library names.
What is must start with letter or underscore, can include only numbers, letters, or underscores?
This common DBMS identifier allows you to utilize the DELIMITER statement later in the code.
What is DLM?
This statement provides SAS with specific instructions for how to read other types of structured data.
What is LIBNAME?
Encountering one of these four statements signifies the end of a SAS program step.
What are the DATA, PROC, QUIT, and RUN statements?
This procedure includes options such as mean, min, mode, n, and range to name a few.
What is PROC MEANS?
This is the default engine SAS uses if one is not specified in the LIBNAME statement.
What is base?
This option is where you provide the data path for the PROC IMPORT.
What is DATAFILE?
OPTIONS VALIDVARNAME=V7;
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).