A00-211 Exam QuestionsBrowse all questions from this exam

A00-211 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?

Show Answer
Correct Answer: AD

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

2 comments
Sign in to comment
mhminkovOption: D
Jun 4, 2021

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
Dec 22, 2020

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