Exam A00-211 topic 1 question 4 discussion

Actual exam question from SAS Institute's A00-211

Question #: 4
Topic #: 1

Given the SAS data set SASDATA TWO:

SASDATA TWO -

X Y -
-- --
5 2
3 1
5 6
The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?

A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations
B. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations
C. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations
D. No data sets are output.

Show Suggested Answer

Suggested Answer: A 🗳️

by Kleinstone at Jan. 3, 2021, 2:10 a.m.

Comments

Submit Cancel

Misty2287

11 months ago

D is the correct answer.

upvoted 1 times

...

Mandar77

2 years ago

All answers for this question are not correct or something is missing in question. I tested the logic with following example data one two three; set sashelp.cars; if type="Sedan" then output one; else output two; run; one : contains rows based on if condtion two: contains all other rows three: Does not have any rows

upvoted 1 times

...

nbav

2 years, 8 months ago

D is the correct answer. The code produces and error

upvoted 1 times

...

Kleinstone

3 years, 6 months ago

if the question is output sasuser.two; the choice is D, no output since sasuser.two is not defined in the code.

upvoted 1 times

...