SASInstitute A00-211 問題集

質問 1：
The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
A. ods file html='sales.html';ods file close;
B. ods html open='sales.html';ods html close;
C. ods file='sales.html' / html;ods file close;
D. ods html file='sales.html';ods html close;
正解：D

質問 2：
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country = City!!', '!!'England';
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
A. Ipswich, 'England'
B. Ipswic h, England
C. Ipswich!!
D. Ipswich, England
正解：D

質問 3：
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. ' ' (missing character value)
B. . (missing numeric value)
C. ,table
D. table
正解：A

質問 4：
The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?
A. ITEMS1, ITEMS2, ITEMS3
B. ITEMS
C. The program fails to execute because there are no variables listed on the ARRAY statement.
D. No variables are created because it is a temporary array.
正解：D

質問 5：
Which of the following programs correctly invokes the DATA Step Debugger?

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

質問 6：
Given the raw data file 'DEPENDENTS.TXT':

The following SAS program is submitted:

What will be the value of _ERROR_ in the Program Data Vector for each iteration of the DATA step?
A. 2
B. 3
C. 4
D. 1
正解：A

質問 7：
The following SAS program is submitted:
data one;
date = '04juI2005'd;
format date weekdate.; run;
proc print data = one; run;
What output is generated?
A. Obs date1 Monday, July 4, 2005
B. Obs date1 04Jul2005
C. Obs date1 Monday, 07/04/2005
D. Obs date1 July4, 2005
正解：A

質問 8：
A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?
A. proc print data = sasuser.houses;where price lt 60000 or price gt 100000;run;
B. proc print data = sasuser.houses;where price lt 60000;where price gt 100000;run;
C. proc print data = sasuser.houses;where price lt 60000 and price gt 100000;run;
D. proc print data = sasuser.houses;where price lt 60000 or where price gt 100000;run;
正解：A