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)- A3% (2)
- B6% (4)
- C12% (8)
- D79% (52)
Community Discussion
No community discussion yet for this question.