nerdexam
SAS_Institute

A00-211 · Question #53

A SAS program is submitted and the following SAS log is produced: 2 data gt100; 3 set ia.airplanes 4 if mpg gt 100 then output; 22 202 ERROR: File WORK.IF.DATA does not exist. ERROR: File…

The correct answer is B. Add a semicolon at the end of the SET statement. See the full explanation below for the reasoning.

Question

A SAS program is submitted and the following SAS log is produced:

2 data gt100; 3 set ia.airplanes 4 if mpg gt 100 then output; 22 202 ERROR: File WORK.IF.DATA does not exist. ERROR: File WORK.MPG.DATA does not exist. ERROR: File WORK.GT.DATA does not exist. ERROR: File WORK.THEN.DATA does not exist. ERROR: File WORK.OUTPUT.DATA does not exist. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, DATA, LAST, NULL. ERROR 202-322: The option or parameter is not recognized and will be ignored. 5 run; The IA libref was previously assigned in this SAS session. Which one of the following corrects the errors in the LOG?

Options

  • ADelete the word THEN on the IF statement.
  • BAdd a semicolon at the end of the SET statement.
  • CPlace quotes around the value on the IF statement.
  • DAdd an END statement to conclude the IF statement

How the community answered

(51 responses)
  • A
    6% (3)
  • B
    78% (40)
  • C
    2% (1)
  • D
    14% (7)

Community Discussion

No community discussion yet for this question.

Full A00-211 Practice