Online Access Free A00-201 Practice Test

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.15
• C.6
• D.200

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.Chem2
• C.Senior Chemist
• D.' ' (missing character value)

A raw data record is listed below:
----|----10---|----20---|----30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile 'file-specification';
input date $ 1 - 10;
< insert statement here>
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?

• A.duration = today( ) - input(date,yymmdd10.);
• B.duration = today( ) - put(date,yymmdd10.);
• C.duration = today( ) - input(date,ddmmyy10.);
• D.duration = today( ) - put(date,ddmmyy10.);

The contents of the raw data file TEAM are listed below:
----|----10---|----20---|----30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?

• A.a raw data file only
• B.No output is generated as the program fails to execute due to errors.
• C.a SAS data set named GROUP only
• D.a SAS data set named GROUP and a raw data file

The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?

• A.. (missing numeric value)
• B.The program fails to execute due to errors.
• C.6
• D.9