General Knowledge
This program should not be used to store data.
What is excel?
This statement protects newly created variables from being reset across iterations of the data step.
What is RETAIN?
These allow us to move through a multi-line input buffer when reading data.
What are line pointer controls?
This is the type of variable for which display is the default usage.
What is character?
This type of loop executes based on a specific condition only.
What is DO UNTIL? or What is DO WHILE?
This procedure allows us to reshape data.
What is PROC TRANSPOSE?
These are the three things that occur when SAS encounters the run statement.
What are outputting the PDV to the dataset, return control back to the top of the data step, reinitializing the IB and PDV.
This statement acts as the catch all when using a select group for executing conditional logic.
What is otherwise?
These are the usages available in PROC REPORT.
What are analysis, display, order, group, across, and compute?
This type of loop is used when we want to allow for the loop to never execute.
What is DO WHILE?
This statement allows for the creation of a user defined macro variable.
What is %let?
The inclusion of this statement (1) in a data step removes this ability (2) from the run statement.
What are (1): the output statement and (2): implicit outputting
This type of line hold specifier protects the input buffer from the run statement.
What is double trailing @?
This term is used to refer to our approach to using PROC REPORT to calculate two (or more) statistics on the same variable. Though they have to have the same usage!
What is alias?
This keyword allows for the use of creation and use of variables that are not in the data set to be used in SAS arrays.
What is _temporary_?
These are the different types of match-merges.
What are 1-1, 1-many and many-many?
This function takes all spaces in the value and changes them to a single space.
What is COMPBL?
These are used to transform the raw data into a form that SAS can store.
What are informats?
Suppose the following code is given:
proc report data=InputDS.Projects;
columns pol_code jobtotal jobtotal=jtmed;
define pol_code / group descending;
define jobtotal / analysis mean;
define jtmed / group;
run;
This is the usage associated with jobtotal.
What is group?
Suppose the following code is executed. What is the value of i in the pdv when the record is output to the dataset?
data LHS05(drop=i);
infile RawData('FlightAttv4.csv') dsd;
input idnum @;
do i = 1 to 4;
input score exam $ @;
output;
end;
run;
What is 5?
These are the three common techniques for dealing with right-censored data.
What are LOCF, WOCF, BOCF?
The input function recasts (1) variables as (2) variables and requires (3)
These are the most common options used when creating a comparison dataset using PROC COMPARE.
What are outbase, outcompare, outdiff, outnoequal, metho=absolute criterion=1E-10?
This statement allows us to format a target cell based on a value from a source cell in a report, even when those cells are different.
What is call define?
Let SAS execute the following array statement:
array MyArray[3,3] VarA VarB VarC VarD VarE VarF VarG VarH VarI;
This variable gets referenced with MyArray[2,2].
What is VarE?