NEW
Font size
WorksheetsSection A Past Year Exam
Total questions: 10
Worksheet time: 10mins
What happens when a DATA step or PROC step contains multiple WHERE statements?
The last WHERE statement replaces previous WHERE statements.
Only the first WHERE statement is processed.
The WHERE conditions are combined with a logical AND operator.
A syntax error is displayed in the log, and the program does not execute.
Which TITLE statement correctly codes the title Analytics Engineering’s Report?
TITLE allowquote(Analytics Engineering's Report);
TITLE "Analytics Engineering's Report";
TITLE ' "Analytics Engineering's Report" ';
TITLE 'Analytic Engineering' ''s Report';
Considering the following PROC SORT step:
PROC SORT data=students;
<insert statement here>
RUN;
Which statement completes the step and sorts the observations in descending order by ID and, within ID, in ascending order by FirstName?
by ID descending FirstName;
by descending ID FirstName;
by descending ID ascending FirstName;
by ID descending FirstName ascending;
The scores.csv file is a comma-delimited raw data file. Which INFILE statement correctly references the file?
INFILE 'sales.csv' dlm=csv;
INFILE 'sales.csv' dlm=comma;
INFILE 'sales.csv';
INFILE 'scores.csv' dlm=',';
Which statement about the DATA step merge is TRUE?
It expects the data to be in sorted order or indexed according to the BY variable.
It is capable of sorting the data.
It uses the ORDER BY clause to sort the data.
It returns only matching rows by default.
Consider the following expression:
Total = P + Q + S;
What is the result of the expression given these values:
P = 9
Q = . (missing)
S = 5
5
9
14
. (missing)
Which statement is used in the DATA step to concatenate multiple data sets?
SET
MERGE
CONCATE
APPEND
Which statement is FALSE concerning the compilation phase of the DATA step?
The DATA step is checked for syntax errors.
Initial values are assigned to the columns.
The program data vector (PDV) is created.
The descriptor portion of the output table is created.
Which function calculates the average of the columns Sales1, Sales2, Sales3, and Sales4?
mean (Sales1, Sales4)
mean (Sales1 – Sales4)
mean (of Sales1 – Sales4)
mean (of Sales1, Sales4)
Which statement is TRUE regarding the iterative DO loop?
DO index-column = start TO stop <BY increment>;
The index column is incremented at the bottom of each DO loop.
The index column is not in the final table unless specifically kept.
The start and stop values can be character or numeric values.
If an increment value is not specified, the default increment is 0.
