SASInstitute A00-280 問題集

質問 1：
Given the SAS data set WORK.BP

What is the result?
A. WORK.HIGHBP has 1 observation WORK.NORMBP has 1 observation WORK.INVESTBP has 2 observations
B. WORK.HIGHBP has 2 observations WORK.NORMBP has 2 observations WORK.INVESTBP has 3 observations
C. WORK.HIGHBP has 1 observation WORK.NORMBP has 1 observation WORK.INVESTBP has 3 observations
D. WORK.HIGHBP has 1 observation WORK.NORMBP has 1 observation WORK.INVESTBP has 4 observations
正解：D

質問 2：
The following SAS program is submitted:
proc sort data=SASUSER.VISIT out=PSORT; by code descending date cost;
run; Which statement is true regarding the submitted program?
A. The PSORT data set is stored in the SASUSER library.
B. The descending option applies to the variable CODE.
C. The variable CODE is sorted by ascending order.
D. The descending option applies to the DATE and COST variables.
正解：C

質問 3：
This question will ask you to provide a missing option.
The following program is submitted to create a transport file for multiple data sets:

Which option will limit the files that are copied to type data?
A. entrytype=data
B. memtype=data
C. intype=data
D. include=data
正解：B

質問 4：
The following SAS program is submitted: data WORK.ALL;

How will the data sets ONE and TWO be combined?
A. match merged
B. updated
C. one-one merged
D. concatenated
正解：D

質問 5：
Given the data set HE:

What will the values be of variable HOSPDURD for the two subjects?
A. 65, 9
B. 5, missing
C. missing, missing
D. 50, 9
正解：C

質問 6：
This question will ask you to provide lines of missing code.
Given the following SCORE data set:

Variable LOCF contains the imputed score that would replace the missing SCORE value (based on last observation carried forward method). Which SAS statements complete the program?
A. retain LOCF ;
if first.subject then LOCF = . ;
if score ^= . then LOCF = score ;
B. retain score ;
if first.subject then LOCF = . ;
if score ^= . then LOCF = score ;
C. if first.subject then LOCF = . ; if score = . then LOCF = lag(score) ;
D. LOCF = lag(score) ; if first.subject then LOCF = . ; if score ^= . then LOCF = score ;
正解：A

質問 7：
Given the following log entry:

Which SAS system option adds the blue highlighted lines to the log?
A. MSGLEVEL=I
B. NOTES
C. INFO
D. INVALIDDATA='I'
正解：A