nerdexam
SAS_Institute

A00-212 · Question #51

Given the SAS dataset ONE ONE SALARY ----------- 200 205 . 523 The following SAS program is submitted proc sql; select * from one <insert WHERE expression here>; quit; The following output is…

The correct answer is D. where salary is not missing. See the full explanation below for the reasoning.

Question

Given the SAS dataset ONE ONE SALARY ----------- 200 205 . 523 The following SAS program is submitted proc sql; select * from one <insert WHERE expression here>; quit; The following output is desired:

SALARY ---------- 200 205 523 Which WHERE expression completes the program and generates the desired output?

Options

  • Awhere salary ne null
  • Bwhere salary is not .
  • Cwhere salary ne missing
  • Dwhere salary is not missing

How the community answered

(66 responses)
  • A
    3% (2)
  • B
    6% (4)
  • C
    12% (8)
  • D
    79% (52)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice