SASInstitute SAS Advanced Programming Exam for SAS 9 (A00-212日本語版) - A00-212日本語 Exam Practice Test
% let value = .5;
% let add = 5;
% let newval = %eval(&value + &add);
Correct Answer: C
% let a=cat;
% macro animal(a=frog);
% let a=bird;
% mend;
% animal(a=pig)
% put a is &a;
Correct Answer: C
Correct Answer: C
ONE TWO
# Variable Type Len Pos # Variable Type Len Pos
2 sales Num 8 8 2 budget Num 8 8
1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
data three;
merge one two;
by year;
run;
Correct Answer: B
Correct Answer: C
options yearcutoff = 1950;
% macro y2kopt(date);
% if &date >= 14610 %then %do;
options yearcutoff = 2000;
% end;
% else %do;
options yearcutoff = 1900;
% end;
% mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
% y2kopt(&date)
Correct Answer: A
Correct Answer:
CORR
Explanation:
Reference:
http://www.koerup.dk/Cert/0104/010405/010405.html
Explanation:
Reference:
http://www.koerup.dk/Cert/0104/010405/010405.html
Correct Answer: D
Correct Answer: D
WORK.INTERNAT
LOCATION SUM
USA 30
EUR 40
% let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc";
quit;
Correct Answer: B
Correct Answer: B
% let test=one;
% let one=two;
% let two=three;
% let three=last;
% put what displays is &&&&&test;
Correct Answer: D
Correct Answer: A
SASUSERS.HOUSES
OBS STYLE
1 RANCH
2 SPLIT
3 CONDO
4 TWOSTORY
5 RANCH
6 SPLIT
7 SPLIT
proc sql noprint;
select distinct style
into :styles separated by ' '
from sasuser.houses
order by style;
quit;
Correct Answer: B