SASInstitute A00-212 問題集

質問 1：
The following SAS program is submitted:
% micro test(var);
% let jobs=BLACKSMITH WORDSMITH SWORDSMITH;
% let type=%index(&jobs, &var);
% put type = &type;
% mend;
% test(SMITH)
What is the value of the macro variable TYPE when the %PUT statement executes?
A. 0
B. 3
C. Null
D. 6
正解：D

質問 2：
The SAS data set ONE contains the variables X, Y, Z, and W.
The following SAS program is submitted:
proc transpose data = one
out = trans
name = new;
by x;
var y;
run;
Which one of the following contains all the names of the columns created by the
TRANSPOSE procedure?
A. new, X, and COL1
B. X, Y, Z, and W
C. new, X, Y, and _COL1_
D. _NAME_, X, and Y
正解：A

質問 3：
The question will ask you to provide a segment of missing code.
The following SAS program is submitted:

The text box above, complete the %PUT statement to produce the following log output:

Case is ignored and standard SAS syntax rules apply.
正解：
_sample_

質問 4：
Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?
A. PRIMARY KEY
B. NOT NULL
C. UNIQUE
D. CHECK
正解：D

質問 5：
The following SAS program is submitted:
options mprint;
% macro test(parm);
proc &parm data = sashelp.prdsale;
run;
% mend;
% test(print)
What is the result of the MPRINT options?
A. It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log
B. It writes the original program code inside the marco definition to the SAS log
C. It writes macro execution messages to the SAS.log
D. It has no effect in this example
正解：A

質問 6：
The following SAS program is submitted:
proc sort data = sales tagsort;
by month year;
run;
Which of the following resource(s) is the TAGSORT option reducing?
A. CPU usage only
B. temporary disk usage
C. I/O and CPU usage
D. I/O usage only
正解：B

質問 7：
Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?
A. RENAME statement only
B. MODIFY and RENAME statements
C. MODIFY and CHANGE statements
D. CHANGE statement only
正解：D

質問 8：
Which one of the following statements about compressed SAS data sets is always true?
A. An updated observation is stored in its original location.
B. Each observation is treated as a single string of bytes.
C. Each observation occupies the same number of bytes.
D. New observations are added to the end of the SAS data set.
正解：B