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.;
if _error_ then description = 'Problems';
else description = 'No Problems';
run;
Which one of the following is the value of the DESCRIPTION variable?
A. The value can not be determined as the program fails to execute due to errors.
B. Problems
C. ' ' (missing character value)
D. No Problems
正解:B
質問 2:
The following SAS program is submitted:
data _null_;
set old;
put sales1 sales2;
run;
Where is the output written?
A. the raw data file that was opened last
B. the data set mentioned in the DATA statement
C. the SAS output window or an output file
D. the SAS log
正解:D
質問 3:
CORRECT TEXT
The SAS data set QTR1_REVENUE is listed below:
The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue;
run;
Which one of the following represents the first observation in the output data set?
正解:
D
質問 4:
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
質問 5:
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?
A. 4
B. 5
C. 6
D. 2
正解:A
質問 6:
The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'Chem2'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
chem2
Which one of the following values does the variable DESCRIPTION contain?
A. Unknown
B. ' ' (missing character value)
C. Chem2
D. Senior Chemist
正解:A
質問 7:
A raw data record is listed below:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'file-specification';
input dept $ 1 - 11 number 13 - 15;
< insert code here>
run;
Which one of the following SAS statements completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
A. department = trim(dept) || number;
B. department = trim(dept) || put(number,3.);
C. department = dept || input(number,3.);
D. department = input(dept,11.) || input(number,3.);
正解:B
中谷** -
A00-201の問題集でしっかり勉強できますし、問題はほぼ試験と同じ内容になっているので安心しました。合格です。