SASInstitute A00-211 問題集

質問 1：
The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
A. The descending option applies only to the Date variable.
B. The descending option applies to the Date and Cost variables.
C. The descending option applies to the Product and Code variables.
D. The descending option applies only to the Code variable.
正解：B

質問 2：
The following SAS program is submitted:
data work.test;
Author = 'Christie, Agatha';
First = substr(scan(author,2,' ,'),1,1);
run;
Which one of the following is the value of the variable FIRST in the output data set?
A. Agatha
B. A
C. ' ' (missing character value)
D. C
正解：B

質問 3：
The following SAS program is submitted:
data combine;
prefix='505';
middle='6465 ';
end='09090';
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-
09090?
A. total = prefix!!'-'!! left(middle)!!'-'!! end;
B. total = cat('-', prefix, middle, end);
C. total = prefix !!'-'!! middle ''!!'-'!! end;
D. total = catx('-', prefix, middle, end);
正解：D

質問 4：
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:

The following SAS program is submitted:

In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.
正解：
See explanation below.
Explanation
by IDNumber Expenses;
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12

質問 5：
The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?
A. SASUSER
B. HOUSES
C. WORK
D. REPORT.
正解：C

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

How many observations does the WORK.OUTDOOR data set contain?
A. 2
B. 3
C. 6
D. 1
正解：A

質問 7：
Which program displays a listing of all data sets in the SASUSER library?
A. proc contents lib = sasuser._alI_; run;
B. proc contents data = sasuser._all_; run;
C. proc contents data = sasuser.all; run;
D. proc contents lib = sasuser.all; run;
正解：B

質問 8：
Given the following IF/THEN statement:
If Age NE 16 and Age NE 15 then Group-1;
Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?
A. where Age not between 15 and 16 then Group=1;
B. if Age not in(15,16) then Group=1;
C. if (Age NE 16) or (Age NE 15) then Group=1;
D. where Age not between (15 and 16) then Group=1;
正解：C