Section A Past Year Exam

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.