SASInstitute SAS Advanced Programming Exam for SAS 9 (A00-212日本語版) (A00-212日本語) Free Practice Test
Question 1
Case is ignored and standard SAS syntax rules apply.
Correct Answer:
North Carolina
Question 2
options reuse=YES;
data sasuser RealEstate(compress=CHAR);
set sasuser houses;
run;
Correct Answer: C
Question 3
Correct Answer: D
Question 4
Correct Answer: C
Question 5
Correct Answer: A
Question 6
Correct Answer: C
Question 7
data new (bufsize = 6144 bufno = 4);
set old;
run;
Correct Answer: D
Question 8
ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
Correct Answer: C
Question 9
% macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "-";
run;
% mend;
% houses(sub = SPLIT)
% houses(dsn = ranch)
% houses(sub = TWOSTORY)
Correct Answer: B
Question 10
data temp(<insert option here>);
infile 'rawdata';
input x $ y z;
run;
Correct Answer: B
Question 11
% let value = 9;
% let value2 = 5;
% let newval = %eval(&value / &value2);
Correct Answer: B
Question 12
Correct Answer: C
Question 13
Correct Answer: D
Question 14
ONE
SALARY
200
205
523
Proc sql;
Select * from one
<Insert Where expression here>;
quit;
SALARY
200
205
523
Correct Answer: B