SASInstitute A00-211 問題集

質問 1：
Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

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

質問 2：
Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?
A. infile 'customer.txt' obs=10;
B. infile 'customer.txt' eof=10;
C. infile 'customer.txt' obs=1-10;
D. infile 'customer.txt' obs=10;
正解：C

質問 3：
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
A. merge work.employeework.salary (fname = name);
B. merge work.employeework.salary (rename = (fname = name));
C. merge work.employeework.salary (name = fname);
D. merge work.employeework.salary (rename = (name = fname));
正解：D

質問 4：
The following SAS program is submitted:
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
A. options reset pageno = 1;
B. options pagenum = 1;
C. options reset pagenum = 1;
D. options pageno = 1;
正解：D

質問 5：
Given the AIRPLANES data set
AlRPLANES
TYPE MPG
-------- ------
F-18 105
C-130 25
Harrier 75
A-6 110
The following SAS program is submitted:
data gt100;
set airplanes(keep = type mpg load);
load = mpg * 150;
run;
The program fails to execute due to syntax errors.
What is the cause of the syntax error?
A. LOAD must be defined prior to the SET statement.
B. MPG is not a numeric variable.
C. LOAD is not variable in the data set AIRPLANES.
D. LOAD is not a variable in the data set GT100.
正解：C

質問 6：
Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input@1 salary 6.;
if_error_then description = 'Problems';
else description = 'No Problems';
run;
What is the result?
A. The value of the DESCRIPTION variable is No Probl.
B. The value of the DESCRIPTION variable is Problems.
C. The value of the DESCRIPTION variable can not be determined.
D. The value of the DESCRIPTION variable is No Problems.
正解：B

質問 7：
Given the SAS data set QTR 1_REVENUE:
destinationrevenue
YYZ53634
FRA62129
FRA75962
RDU76254
YYZ82174
The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue; run;
What is the first observation in the output data set?
A. destination revenueYYZ 82174
B. destination revenueFRA 62129
C. destination revenueFRA 75962
D. destination revenueYYZ 53634
正解：C

質問 8：
The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?
A. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
B. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
C. Nothing is produced by the SUM statement; the program fails to execute.
D. The SUM statement produces only a grand total of NUMBER.
正解：D