最新なSASInstitute A00-211問題集（275題）、真実試験の問題を全部にカバー！

質問 1：
The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
A. No value is stored as the program fails to execute due to errors.
B. 25.31
C. . (missing numeric value)
D. $25.31
正解：C

質問 2：
A raw data file is listed below:
--------10-------20-------30
squash 1.10
apples 2.25
juice 1.69
The following SAS program is submitted using the raw data file above:
data groceries;
infile 'file-specification';
input item $ cost;
run;
Which one of the following completes the program and produces a grand total for all COST values?
A. grandtot = sum(grandtot,cost);output grandtot
B. grandtot = sum cost;
C. grandtot = sum(grandtot,cost);
D. retain grandtot 0;grandtot = sum(grandtot,cost);
正解：D

質問 3：
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

質問 4：
A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH' then
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations does the WORK.CONDO_RANCH data set contain?
A. 0
B. 5
C. 3
D. 7
正解：D

質問 5：
The following SAS program is submitted:
data revenue;
set year_1;
var1 = mdy(1,15,1960);
run;
Which one of the following values does the variable named VAR1 contain?
A. 1151960
B. 14
C. '1/15/1960'
D. 15
正解：B

質問 6：
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?
A. The program fails to execute due to errors.
B. The type of the variable CharEmpid is unknown.
C. The type of the variable CharEmpid is character.
D. The type of the variable CharEmpid is numeric.
正解：A

質問 7：
After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, <=, <>, =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?
A. (drop=Month, Quantity, Cost)
B. (drop=Month Quantity Cost)
C. (drop Month, Quantity, Cost)
D. (drop Month Quantity Cost)
正解：B

質問 8：
When SAS encounters a data when reading from a raw data file, which action will occur?
A. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
B. SAS will write a WARNING message to the SAS log and suspend execution.
C. SAS will write an ERROR message to the SAS log and suspend execution.
D. SAS will write a NOTE to the SAS log and continue execution.
正解：A