The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price". Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
A. proc print data = sasuser.houses label; label price = "Sale Price"; run;
B. proc print data = sasuser.houses; price = "Sale Price"; run;
C. proc print data = sasuser.houses; label price = "Sale Price"; run;
D. proc print data = sasuser.houses label; label price "Sale Price"; run;
正解:A
質問 2:
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 can not be determined.
B. The value of the DESCRIPTION variable is No Problems.
C. The value of the DESCRIPTION variable is No Probl.
D. The value of the DESCRIPTION variable is Problems.
正解:D
質問 3:
The following SAS DATA step is submitted:
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?
A. The data sets listed in the first two IF statements require a library reference.
B. The data sets listed on all the IF statements require a library reference.
C. The data sets listed in the last two IF statements require a library reference.
D. No library references are required.
正解:A
質問 4:
The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
A. 0
B. 5
C. 1
D. 60
正解:C
質問 5:
Given the SAS data set PERM.STUDENTS:
PERM.STUDENTS NAMEAGE
---------------- Alfred14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $ age;
<insert statement here>
run;
The following double-spaced file is desired as output
Alfred 14
Alice 13
Barbara 13
Carol 14
Which statement completes the program and creates the desired file?
A. put/;
B. put
C. double;
D. put _null_;
正解:B
質問 6:
Given the SAS data set WORK.ORDERS:
The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
Which of the following statement will correctly create the value and assign it to ship_note?
A. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);
B. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
C. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
D. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
正解:B
質問 7:
The following SAS program is submitted:
footnote1 'Sales Report for Last Month';
footnote2 'Selected Products Only';
footnote3 'All Regions';
footnote4 'All Figures in Thousands of Dollars';
proc print data = sasuser.shoes;
footnote2 'All Products';
run;
Which footnote(s) is/are displayed in the report?
A. All Products All Regions All Figures in Thousands of Dollars
B. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars
C. Sales Report for Last Month All Products
D. All Products
正解:C
質問 8:
How many of the following SAS data set names are valid?
A. 4
B. 1
C. 3
D. 2
正解:D
Matsushita -
詳細な解説だお気に入りです。素晴らしい問題集に出会いさせてもらったPass4Testに感謝しかないです。