Click the Exhibit button to view a listing of the SASUSER.HOUSES data set.
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price lt 100000;
< insert DEFINE statement here>
define price / mean width = 9;
title;
run;
The following ouput is created by the REPORT procedure:
Which one of the following DEFINE statements completes the above program and produces the above output?
A. define style / order width = 9;
B. define style / display width = 9;
C. define style / group width = 9;
D. define style / across width = 9;
正解:C
質問 2:
Which one of the following SAS system options prevents the page number from appearing on a report?
A. NONUMBER
B. NOPAGENUM
C. NOPAGE
D. NONUM
正解:A
質問 3:
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. A
B. C
C. Agatha
D. ' ' (missing character value)
正解:A
質問 4:
Which one of the following ODS statement options terminates output being written to an
HTML file?
A. QUIT
B. STOP
C. CLOSE
D. END
正解:C
質問 5:
The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
< insert DO statement here>
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?
A. do i = 1 to 5;
B. A DO loop cannot be used because the variables referenced do not end in a digit.
C. do weekly{i} = 1 to 5;
D. do i = mon tue wed thu fri;
正解:A
質問 6:
In the following SAS program, the input data files are sorted by the NAMES variable:
libname temp 'SAS-data-library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
Which one of the following results occurs when this program is submitted?
A. The program executes successfully and a permanent SAS data set is created.
B. The program executes successfully and a temporary SAS data set is created.
C. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
D. The program fails execution because the same SAS data set is referenced for both read and write operations.
正解:A
質問 7:
The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?
A. (space)
B. , (comma)
C. ; (semicolon)
D. : (colon)
正解:A
相沢** -
スマートフォンからアクセスしてもできるので、電車での移動中でも利用していました。それのおかげで試験にも無事合格しました。