This question will ask you to provide a segment of missing code.
Given the SAS data set SASUSER.HIGHWAY:
The following SAS program is submitted:
Which SQL clause stores the text 0-29, 30-49, 60+ in the macro variable GROUPS?
A. : into GROUPS delimited by ' , '
B. : into GROUPS separated = ' , '
C. into : GROUPS separated by ' , '
D. Into : GROUPS delimited by ' , '
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Given the non-indexed SAS data set TEMP:
TEMP
X Y
--
P 52
P 45
A 13
A 56
R 34
R 12
R 78
The following SAS program is submitted:
Proc print data=temp;
<insert BY statement here>
run;
Which BY statement completes the program, creates a listing report that is grouped by X and completes without
errors?
A. By Descending X;
B. By X;
C. By X notsorted;
D. By X grouped;
正解:C
質問 3:
This question will ask you to provide a segment of missing code.
Given the following program and data:
What is the WHERE statement that successfully completes the PROC PRINT and selects the observation from Barb?
A. Where Birthday=&"Want";
B. Birthday=&"Want" d;
C. Where Birthday=&'Want' d;
D. Birthday=&Want;
正解:A
質問 4:
Given the data set shown in the left, the SAS program on the right is submitted.
Which program will result in the identical report?
A. Option C
B. Option A
C. Option D
D. Option B
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
The following SAS program is submitted:
options yearcutoff = 1950;
% macro y2kopt(date);
% if &date >= 14610 %then %do;
options yearcutoff = 2000;
% end;
% else %do;
options yearcutoff = 1900;
% end;
% mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
% y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for
YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?
A. 2000
B. 1900
C. 1950
D. 1920
正解:A
質問 6:
When reading a SAS data file, what does the NOBS=option on the SET statement represent?
A. A variable that represents the total number of observation in the output data set(s)
B. A variable that represents the total number of observations in the input data set(s)
C. A variable that represents the current observation number
D. A variable that represents a flag indicating the end of the file
正解:B
川西** -
先週A00-212認定資格を取得しました。Pass4Test様がかなり実力をつけてくださったおかげだと思います。
こころから感謝します。