최신 SAS Institute Systems Certification A00-201 무료샘플문제:
1. The following SAS program is submitted:
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?
A) 1
B) 200
C) 6
D) 15
2. The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'chem3'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?
A) Unknown
B) Senior Chemist
C) chem3
D) ' ' (missing character value)
3. The contents of the raw data file AMOUNT are listed below:
----|----10---|----20---|----30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input @1 salary 6.;
run;
Which one of the following is the value of the SALARY variable?
A) 1,234
B) 1234
C) $1,234
D) . (missing numeric value)
4. The following SAS program is submitted:
proc freq data = sales;
< insert TABLES statement here>
run;
Click the Exhibit button to view the output from the FREQ procedure.
Which one of the following statements completes the program and produces the output?
A) tables region product;
B) tables region * product;
C) tables product * region;
D) tables product region;
5. The contents of the SAS data set named PERM.STUDENTS are listed below:
The following SAS program is submitted using the PERM.STUDENTS data set as input:
libname perm 'SAS-data-library';
data students;
set perm.students;
file 'file-specification';
put name $15. @5 age 2.;
run;
Which one of the following represents the values written to the output raw data file?
A) ----|----10---|----20---|----30----|----10---|----20---|----30
Alfred 14
Alice 13
Barbara 13
Carol 14
B) ----|----10---|----20---|----30
Alfr14
Alic13
Barb13a
Caro14
C) ----|----10---|----20---|----30
Alfr14ed
Alic13e
Barb13ara
Caro14l
D) ----|----10---|----20---|----30
Alfred 14
Alice 13
Barbara 13
Carol 14
질문과 대답:
질문 # 1 정답: B | 질문 # 2 정답: A | 질문 # 3 정답: D | 질문 # 4 정답: B | 질문 # 5 정답: B |