SAS Training questions with correct
answers rated A+
Error 180-322: Statement is not valid or it is used out of proper order - correct answer ✔✔
Probably means you forgot a semicolon at the end of a statement
3 types of steps in SAS program - correct answer ✔✔ DATA step, PROC step, and Global
statements
DATA step - correct answer ✔✔ creates a dataset and manipulates data as desired
PROC step - correct answer ✔✔ Reads a SAS dataset and performs some canned procedure
Global statements - correct answer ✔✔ indicates some options or directive to be accessible
during a future DATA or PROC step
set statement - correct answer ✔✔ reads in an existing data set to a DATA step
run; - correct answer ✔✔ used to end a step
for each and every row, SAS repeats the execution of every line of code in a DATA step - correct
answer ✔✔ jsyk
When you define a dataset in SAS without specifying a library it gets stored in a temporary
library called WORK - correct answer ✔✔ So set NFL_Census; is the same statement as
set WORK.NFL_Census;
, Creating a library - correct answer ✔✔ libname CONGRESS
'/nas/igarc04/work/ew21/users/tlawt';
commenting in SAS - correct answer ✔✔ /* comment */
Always click rename columns to comply with SAS naming conventions when importing data -
correct answer ✔✔ jsyk
PROC CONTENTS data=datasetname; - correct answer ✔✔ shows number of
records/observations in data set, number of variables in data set and list of variables in data set.
PROC FREQ data=datasetname;
tables
variable1
variable2
etc.
;
run; - correct answer ✔✔ shows the number of records corresponding to each value of the
variables you are interested in. (Just put semicolon after the last variable)
In proc FREQ if you set
tables
variable1*variable2;
/ nofreq
run; - correct answer ✔✔ you can see number of observations, percent of total, row %, col % of
each combination of variable1 and variable2. The "/ nofreq" part will leave number of
observations out of the out put table.
answers rated A+
Error 180-322: Statement is not valid or it is used out of proper order - correct answer ✔✔
Probably means you forgot a semicolon at the end of a statement
3 types of steps in SAS program - correct answer ✔✔ DATA step, PROC step, and Global
statements
DATA step - correct answer ✔✔ creates a dataset and manipulates data as desired
PROC step - correct answer ✔✔ Reads a SAS dataset and performs some canned procedure
Global statements - correct answer ✔✔ indicates some options or directive to be accessible
during a future DATA or PROC step
set statement - correct answer ✔✔ reads in an existing data set to a DATA step
run; - correct answer ✔✔ used to end a step
for each and every row, SAS repeats the execution of every line of code in a DATA step - correct
answer ✔✔ jsyk
When you define a dataset in SAS without specifying a library it gets stored in a temporary
library called WORK - correct answer ✔✔ So set NFL_Census; is the same statement as
set WORK.NFL_Census;
, Creating a library - correct answer ✔✔ libname CONGRESS
'/nas/igarc04/work/ew21/users/tlawt';
commenting in SAS - correct answer ✔✔ /* comment */
Always click rename columns to comply with SAS naming conventions when importing data -
correct answer ✔✔ jsyk
PROC CONTENTS data=datasetname; - correct answer ✔✔ shows number of
records/observations in data set, number of variables in data set and list of variables in data set.
PROC FREQ data=datasetname;
tables
variable1
variable2
etc.
;
run; - correct answer ✔✔ shows the number of records corresponding to each value of the
variables you are interested in. (Just put semicolon after the last variable)
In proc FREQ if you set
tables
variable1*variable2;
/ nofreq
run; - correct answer ✔✔ you can see number of observations, percent of total, row %, col % of
each combination of variable1 and variable2. The "/ nofreq" part will leave number of
observations out of the out put table.
