A SAS program is submitted and the following SAS log is produced:
2 data gt100;
3 set ia.airplanes
4 if mpg gt 100 then output;
22 202
ERROR: File WORK.IF.DATA does not exist.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
5 run;
The IA libref was previously assigned in this SAS session.
Which one of the following corrects the errors in the LOG?
A. Delete the word THEN on the IF statement.
B. Place quotes around the value on the IF statement.
C. Add a semicolon at the end of the SET statement.
D. Add an END statement to conclude the IF statement
正解:C
質問 2:
The contents of the raw data file FURNITURE are listed below:
--------10-------20-------30
chair,,table
chair,couch,table
The following SAS program is submitted:
data stock;
infile 'furniture' dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?
A. ,table
B. table
C. ' ' (missing character value)
D. . (missing numeric value)
正解:C
質問 3:
Which program will create a comma delimited raw data file (CSV)?
正解:
Pending
質問 4:
Given the SAS data set WORK.PRODUCTS:
How many observations does the WORK.OUTDOOR data set contain?
A. 1
B. 3
C. 6
D. 2
正解:D
質問 5:
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
A. 400 for PROC PRINT4500 for PROC MEANS
B. 401 for PROC PRINT4501 for PROC MEANS
C. 401 for PROC PRINT4500 for PROC MEANS
D. 500 for PROC PRINT5000 for PROC MEANS
正解:B
質問 6:
The SAS data set EMPLOYEE_INFO is listed below:
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
The following SAS program is submitted:
proc sort data = employee_info;
run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?
A. by descending IDNumber Expenses;
B. by IDNumber descending Expenses descending;
C. by descending IDNumber descending Expenses;
D. by (IDNumber Expenses) descending;
正解:C
質問 7:
Which program displays a listing of all data sets in the SASUSER library?
A. proc contents lib = sasuser._alI_; run;
B. proc contents lib = sasuser.all; run;
C. proc contents data = sasuser._all_; run;
D. proc contents data = sasuser.all; run;
正解:C
質問 8:
Given the SAS data set PRICES:
PRICES
Prodid priceproducttypesalesreturns
K1255.10NETWORK152
B132S 2.34HARDWARE30010
R18KY2 1.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
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; How many observations does the HWARE data set contain?
A. 0
B. 4
C. 3
D. 2
正解:B
Takasugi -
A00-211試験を合格しました。肝心なのは本書の模擬試験も実践さながらで、ダメだった所が問題選択できて反復練習することです。とても役に立つ参考書だと思います。ありがとうございました。