Show:
Formats
Random Sampling
Proc Transpose
Efficiencies
Table Lookups
100
The name of the column that has the beginning reference value when using CNTLIN.
What is START?
100
The lower and upper limit of ranuni results.
What are 0 and 1?
100
The keyword that indicates the transposed columns.
What is VAR?
100
Of data steps, proc steps, and neither, the one that does calculations faster.
What is the DATA STEP?
100
A list or range of values may determine the lookup value.
What are FORMATS?
200
The name of the column that has the lookup value result when using CNTLIN.
What is LABEL?
200
The result is a read of a specific observation number.
What is the SET statement with POINT= option?
200
The option that indicates the new variable that contains the list of transposed variables.
What is NAME=?
200
The alternative statement to the BY statement that does not require sorting.
What is CLASS?
200
The preferred method when a large number of distinct values are in the source variable.
What is the SET or INDEX method?
300
The option that allows the unformatted value to appear when the referenced format has been deleted.
What is NOFMTERR?
300
The statement that ends a data step with no end of file marker.
What is STOP?
300
The option that indicates the starting character string for the new column names.
What is PREFIX=?
300
The option that displays the most resource information in the log.
What is FULLSTIMER?
300
Multiple tables can be joined without a common column.
What is SQL?
400
The name of the column that has the format name being loaded when using CNTLIN.
What is FMTNAME?
400
The statement that is required when a specific observation number value is requested.
What is OUTPUT?
400
The keyword that indicates the variable containing the new column names.
What is ID?
400
The approach that is better than multiple individual "if" comparisons.
What is the IN construction? (or What is user formats?)
400
Multiple numeric values or expressions determine the lookup value.
What is the ARRAY method?
500
The option that specifies the order of libraries examined when referencing a user format.
What is FMTSEARCH?
500
The result is a random list of numbers that is the same as prior run.
What is a RANUNI function with positive parameter?
500
The keyword that determines the number of observations in the transposed data set.
What is BY?
500
The efficient way to programmatically add formats and labels on existing large data sets.
What is PROC DATASETS?
500
The preferred method if there are a few different values but not many are unique.
What is the MACRO variable method?