Advance SAS CertifIcation Exam Question5

Given the SAS data set SASDATA.TWO:

SASDATA.TWO

X Y

-- __

5 2

5 4

3 6

The following SAS program is submitted:

data sasuser.one one sasdata.three;

set sasdata two;

if x = 5 then output sasuser.one;

else output sasdata three;

run;

What is the result?

A - The data set SASUSER.ONE has 0 observations, the data set ONE has 0 observations, and

the data set SASDATA.THREE has 0 observations.

B - The data set SASUSER.ONE has 2 observations, the data set ONE has 0 observations, and

the data set SASDATA.THREE has 1 observation.

C - The data set SASUSER.ONE has 2 observations, the data set ONE has 3 observations, and

the data set SASDATA.THREE has 1 observation.

D - No data sets are output. The DATA step fails execution due to errors.

Answer: B