SASInstitute A00-211日本語 問題集

質問 1：

data test;
set chemists;
jobcode = 'Chem2'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
The value for the variable JOBCODE is:
JOBCODE
chem2

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

質問 2：

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

質問 3：

data newstaff;
set staff;
start_date = today();
run;

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

質問 4：

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

質問 5：

A. proc print data=SASUSER.HOUSES label;
label Open_Date="Starting Date";
run;
B. proc print data=SASUSER.HOUSES;
Open_Date="Starting Date";
run;
C. proc print data=SASUSER.HOUSES label;
label Open_Date "Starting Date";
run;
D. proc print data=SASUSER.HOUSES;
label Open_Date="Starting Date";
run;
正解：A

質問 6：





正解：
Pending

質問 7：



proc print data=WORK.ONE;
where Num=contains (1);
run;

正解：
No output is generated

質問 8：

--------10-------20-------30
$1,234

data test;
infile 'amount';
input @1 salary 6.;
if _error_ then description = 'Problems';
else description = 'No Problems';
run;

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

質問 9：

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