SASInstitute A00-211 問題集

質問 1：
Given the following raw data records in TEXTFILE.TXT:

The following output is desired:

Which SAS program correctly produces the desired output?

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

質問 2：
The following SAS program is submitted:
data numrecords;
infile 'file specification';
input@1 patient $15.
relative$ 16-26@;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15.
clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step execution?
A. 2
B. 3
C. 4
D. 1
正解：A

質問 3：
Which step displays a listing of all the data sets in the WORK library?
A. proc contents lib=WORK.all;run;
B. proc contents data=WORK _ALL_;run;
C. proc contents data=WORK._all_;run;
D. proc contents lib=WORKrun;
正解：C

質問 4：
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
A. department=trim(dept)||put(number,3.);
B. department = dept II number;
C. department = trim(dept) number;
D. department = left(dept) II number;
正解：A

質問 5：
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
A. ods html = 'sales.html'; ods html close;
B. ods file = 'sales.html'; ods file close;
C. ods html file = 'sales.html'; ods html close;
D. ods file html = 'sales.html'; ods file close;
正解：C

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

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following:
"Order 9341 shipped on 02FEB2009".
Which of the following statement will correctly create the value and assign it to Note?
A. note=catx(' ','Order',order_id,'shipped on',transwrd(ship_date,date9.));
B. note=catx(' ','Order',order_id,'shipped on',put(ship_date,date9.));
C. note=catx(' ','Order',order_id,'shipped on',char(ship_date,date9.));
D. note=catx(' ','Order',order_id,'shipped on',input(ship_date,date9.));
正解：B

質問 7：
There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

What will be the value of NewVar when SAS writes the last observation?
A. 0
B. . (a missing value)
C. 451
D. 1
正解：C

質問 8：
This question will ask you to provide lines of missing code.
The following SAS program is submitted:

Which statement inserted, respectively, in the two locations indicated above create a report stored in a PDF file?
正解：
Pending