1. Given the SAS data sets ONE and TWO: ONE TWONUM COUNTRY NUM CITY 1 CANADA 3 PARIS
2 FRANCE 5 TOKYO 3 GERMANY 4 BELGIUM 5 JAPAN The following SAS program is submitted: proc
sql; select country from one where not exists (select * from two where one.num = two.num); quit; Which
report is generated? A.COUNTRYFRANCEJAPAN
B.COUNTRYGERMANYJAPAN
C.COUNTRYCANADAFRANCEBELGIUM
D.COUNTRY FRANCEGERMANYBELGIUM
Answer: C
2. Given the SAS data set ONE: ONEREP COST SMITH 200 SMITH 400 JONES 100 SMITH 600
JONES 100 The following SAS program is submitted: proc sql; select rep, avg(cost) as AVERAGE from
one group by rep quit; The following output is desired: REP AVERAGE SMITH 400 Which SQL procedure
clause completes the program and generates the desired output?
A.having avg(cost) < select avg(cost) from one);
B.where avg(cost) > (select avg(cost) from one);
C.having avg(cost) > (select avg(cost) from one);
D.where calculated average > (select avg(cost) from one);
Answer: C
these questions and answers come from : http://www.testpassport.com/SASInstituteSystemsCertification/A00-212.asp
