Examice

Exam A00-211 All QuestionsBrowse all questions from this exam

Go to Exam

Question 34

After a SAS program is submitted, the following is written to the SAS log:

105 data WORK.JANUARY;

106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);

107 if Month='JAN' then output WORK.JANUARY;

108 Sales=Cost * Quantity;

109 drop=Month Quantity Cost;

-----

ERROR 22-322: Syntax error, expecting one of the following: !,

!!, , *, **, +, -,

, <=, <>, =, >, >=,

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,

NOTIN, OR, ^=, |, ||, ~=.

110 run;

What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?

(drop Month Quantity Cost)

(drop Month, Quantity, Cost)

(drop=Month, Quantity, Cost)

(drop=Month Quantity Cost)

Correct Answer: A

The syntax for a data set option in SAS follows the format (option=value). The correct option removes the need for an equal sign and commas, using spaces to separate the variables. Thus, the correct answer is (drop Month Quantity Cost). Option A correctly follows this syntax.

Discussion

mhminkovOption: D

given answer D is correct, as the question is clearly about "data set option", not a statement. Even if the question was about a statement, A option should not contain parentheses ( ).

KleinstoneOption: A

A or D? for a statement is it should be A?