SASInstitute A00-211 問題集

質問 1：
Given the SAS data set WORK. PRODUCTS:

The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns);
Revenue-Price* (Sales-Returns);
run;
How many variables does the WORK.REVENUE data set contain?
A. 2
B. 3
C. 4
D. 5
正解：D

質問 2：
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:

What does it mean?
A. The 1st of potentially many errors, this one occurring on the 4th observation.
B. An error on the INPUT statement specification for reading the variable Salary.
C. A compiler error, triggered by an invalid character for the variable Salary.
D. An execution error, triggered by an invalid character for the variable Salary.
正解：D

質問 3：
The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
A. Wang 3Gerard 3Wang 2Amy 2Wang 1Amy 1
B. Wang 1Wang 2Wang 3Gerard 3Amy 1Amy 2
C. Wang 3Wang 1Wang 2Gerard 3Amy 2Amy 1
D. Wang 3Wang 2Wang 1Gerard 3Amy 2Amy 1
正解：B

質問 4：
The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
A. The PSORT data set is stored in the SASUSER library.
B. The descending option applies to the variable Code.
C. The variable Code is sorted by ascending order.
D. The descending option applies to the Date and Cost variables.
正解：C

質問 5：
The following SAS program is submitted:

What is the value of the variable Prod in the output data set?
A. 8
B. 6
C. 7
D. . (missing numeric)
正解：C

質問 6：
The following SAS program is submitted:

What is the value of the second variable in the data set WORK.AUTHORS?
A. Hemingway
B. Hemingwa
C. ' ' (a missing value)
D. The program contains errors. No variables are created.
正解：B

質問 7：
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. 500 for PROC PRINT5000 for PROC MEANS
B. 401 for PROC PRINT4500 for PROC MEANS
C. 401 for PROC PRINT4501 for PROC MEANS
D. 400 for PROC PRINT4500 for PROC MEANS
正解：C

質問 8：
The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
A. 2 temporary and 2 permanent SAS data sets are created
B. 2 temporary and 1 permanent SAS data sets are created
C. 3 temporary and 2 permanent SAS data sets are created
D. there is an error and no new data sets are created
正解：D