SASInstitute SAS Base Programming for SAS 9 (A00-211日本語版) - A00-211日本語 Exam Questions
QUESTION NO: 1
Correct Answer: A
QUESTION NO: 2
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
Correct Answer: B
QUESTION NO: 3
data work.accounting;
set work.dept1 work.dept2;
jobcode = 'FA1';
length jobcode $ 8;
run;
data work.accounting;
set work.dept1 work.dept2;
jobcode = 'FA1';
length jobcode $ 8;
run;
Correct Answer: C
QUESTION NO: 4
Correct Answer: A
QUESTION NO: 5
EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
Correct Answer: D
QUESTION NO: 6
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Correct Answer: B
QUESTION NO: 7
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Correct Answer:
Pending
QUESTION NO: 8
Obs name level 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1
Obs name level 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1
Correct Answer: D
QUESTION NO: 9
Correct Answer: A
QUESTION NO: 10
proc freq data = WORK.SALES;
<insert code here>
run;
proc freq data = WORK.SALES;
<insert code here>
run;
Correct Answer: C
