topic sample question no.10 in SAS Certification

sample question no.10

anming — Sat, 28 Nov 2020 00:46:20 GMT

Given the SAS data set WORK.INPUT:
Var1 Var2
------ -------
A one
A two
B three
C four
A five
The following SAS program is submitted:
data WORK.ONE WORK.TWO;
set WORK.INPUT;
if Var1='A' then output WORK.ONE;
output;
run;
How many observations will be in data set WORK.ONE?

I do not understand why the observation is 8. I only got 3 observations when Var1 is A.

Re: sample question no.10

PaigeMiller — Sat, 28 Nov 2020 01:07:15 GMT

@anming wrote:

Given the SAS data set WORK.INPUT:
Var1 Var2
------ -------
A one
A two
B three
C four
A five
The following SAS program is submitted:
data WORK.ONE WORK.TWO;
set WORK.INPUT;
if Var1='A' then output WORK.ONE;
output;
run;
How many observations will be in data set WORK.ONE?

I do not understand why the observation is 8. I only got 3 observations when Var1 is A.

Let's see here: one line tests to see if VAR1='A' and then outputs three records to WORK.ONE. The next line outputs all records to WORK.ONE. That's 8

Re: sample question no.10

anming — Sat, 28 Nov 2020 03:49:14 GMT

data test;
input var1$ var2$;
datalines;
A one
A Two
B Three
C four
A five
;
run;

data work.one work.two;
set test;
if var1='A' then output work.one;
output;
run;

these are test codes. 

work.one has 8 observions while work.two has 5 observions. Wonderful!