SASInstitute A00-211日本語 問題集

質問 1：

PERM.STUDENTS NAME AGE
--------- ------ Alfred 14
Alice13
Barbara13
Carol14

libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $15. @5 age 2.;
run;

A. ----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
B. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14
C. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
D. ----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14
正解：A

質問 2：

data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;

A. 0
B. 12
C. 7
D. 5
正解：A

質問 3：

SASDATA TWO XY
52
31
56

data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;

A. Option A
B. Option C
C. Option D
D. Option B
正解：C

質問 4：







A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 5：

data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;

A. Option A
B. Option C
C. Option D
D. Option B
正解：B

質問 6：





正解：
Pending

質問 7：

data WORK.PRODUCTS;
Prod=1;
do while (Prod LE 7);
Prod + 1;
end;
run;

A. .(missing numeric)
B. 8
C. 6
D. 7
正解：B

質問 8：

fname points Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2

proc sort data = work.awards;
by descending fname points;
run;

A. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1
B. Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2
C. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1
D. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1
正解：B

質問 9：

PRICES
Prodid priceproducttypesalesreturns K1255.10NETWORK152 B132S 2.34HARDWARE30010 R18KY2 1.29SOFTWARE255 3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672

data hware inter cheap;
set prices(keep = productype price);
if producttype = 'HARDWARE' then output hware; else if producttype = 'NETWORK'
then output
inter; if price le 5.00;
run;
if producttype = 'HARDWARE' then output hware; else if producttype = 'NETWORK' then
output
inter; if price le 5.00;
run;

A. 0
B. 2
C. 3
D. 4
正解：D