SAS BASE CERTIFICATION QUESTIONS & ANSWERS
c - Answers -Which of the following will select from a data set only those observations
for which the value of the variable Genre is SciFi, Western, or Classic?
a.where genre='SciFi' or 'Western' or 'Classic';
b.where genre is SciFi Western Classic;
c.where genre in ('SciFi', 'Western', 'Classic');
d.where genre in (SciFi, Western, Classic);
b - Answers -What happens when the following program is run?
proc sort data=black.book;
run;
proc print data=black.book;
var name age number;
where status='Single';
run;
a. The PROC PRINT step is successful, providing list in sorted order.
b. The PROC SORT generates an error in the log, the PROC PRINT step runs.
c. The PROC SORT step permanently sorts the data set.
d. The PROC SORT runs successfully, PROC PRINT generates errors
d - Answers -In the DATA step, how can you reference the temporary SAS data set
named Dating
a. Dating
b. Work.Dating
c. Pool.Dating (after assigning the libref Pool)
d. a and b
a - Answers -Which of the following is a valid variable name?
a. _Units_
b. 2Cool
c. Total$
d. Days-To-Ship
d - Answers -Which of the following contains a syntax error?
a. None of these
b.proc print data=sales.location;
label loc='Franchise Location';
run;
c.proc sort data=work.sales;
by month;
, run;
d.dat homework.test;
set homework.quiz;
run;
c - Answers -A syntax error occurs when
a. the form of the elements of the SAS statement are correct but their usage is not.
b. none of these.
c. programming statements that do not conform to the rules of the SAS language.
d. some data values are not appropriate for the SAS statements.
d - Answers -What usually happens when a syntax error is detected?
a. SAS continues to process the step, and the SAS log displays messages about the
error.
b. SAS continues to process the step.
c. SAS stops processing the step in which the error occurred, and the Output window
displays messages about the error.
d. SAS stops processing the step in which the error occurred, and the SAS log displays
messages about the error
a - Answers -What is the default length of the variable BALANCE?
Name Balance
Andrews 123.21
Smithy 92.31
Keeley 2812.23
Cist 981.99
a. 8
b. 32
c. 0
d. 16
a - Answers -If SAS cannot interpret a syntax error, then
a. the DATA step compiles but does not execute.
b. the DATA step does not compile.
c. the DATA step compiles and executes.
d. the variables in the data set will all be set to missing values.
d - Answers -Which statement identifies the name of a raw data file to be read with the
fileref Jobs and specifies that the DATA step only read records 1-20?
a. infile jobs obs 20;
b. infile jobs 1-20;
, c. input jobs 1-20;
d. infile jobs obs=20;
e. input jobs obs=20;
a - Answers -What is not created in the compilation phase of the DATA step?
a. the first observations
b. the automatic variables _N_ and _ERROR_
c. the data set descriptor
d. the program data vector
d - Answers -Which of the following statements will process only the records above
where Driver is SS?
a. a or c
b.if driver=SS
c.if driver is SS
d.if driver='SS'
b - Answers -During the compilation phase, SAS checks each statement looking for
syntax errors. Which of the following is not a syntax error?
a. missing or invalid punctuation
b. improper formats and incorrect values
c. missing or misspelled keywords.
d. invalid options or variable names
c - Answers -How would you create a list report of an Excel sheet?
a.data work.new; infile xldat.'Sheet1$'; input var1 var2 var3; run; proc print
data=work.new; run;
b.proc print data=xldat; sheet = 'Sheet1'; run;
c.proc print data=xldat.'Sheet1$'n; run;
d.proc print data=xldat.'Sheet1$'; run;
d - Answers -When you run a SAS program to read in biographical information, an error
occurs from the 3rd to the 20th records due to a change of format in the DoB column.
What is the value of _ERROR_ after the 17th record is read in?
a. 0
b. 14
c. 3
d. 1
b - Answers -The DATA step will execute
c - Answers -Which of the following will select from a data set only those observations
for which the value of the variable Genre is SciFi, Western, or Classic?
a.where genre='SciFi' or 'Western' or 'Classic';
b.where genre is SciFi Western Classic;
c.where genre in ('SciFi', 'Western', 'Classic');
d.where genre in (SciFi, Western, Classic);
b - Answers -What happens when the following program is run?
proc sort data=black.book;
run;
proc print data=black.book;
var name age number;
where status='Single';
run;
a. The PROC PRINT step is successful, providing list in sorted order.
b. The PROC SORT generates an error in the log, the PROC PRINT step runs.
c. The PROC SORT step permanently sorts the data set.
d. The PROC SORT runs successfully, PROC PRINT generates errors
d - Answers -In the DATA step, how can you reference the temporary SAS data set
named Dating
a. Dating
b. Work.Dating
c. Pool.Dating (after assigning the libref Pool)
d. a and b
a - Answers -Which of the following is a valid variable name?
a. _Units_
b. 2Cool
c. Total$
d. Days-To-Ship
d - Answers -Which of the following contains a syntax error?
a. None of these
b.proc print data=sales.location;
label loc='Franchise Location';
run;
c.proc sort data=work.sales;
by month;
, run;
d.dat homework.test;
set homework.quiz;
run;
c - Answers -A syntax error occurs when
a. the form of the elements of the SAS statement are correct but their usage is not.
b. none of these.
c. programming statements that do not conform to the rules of the SAS language.
d. some data values are not appropriate for the SAS statements.
d - Answers -What usually happens when a syntax error is detected?
a. SAS continues to process the step, and the SAS log displays messages about the
error.
b. SAS continues to process the step.
c. SAS stops processing the step in which the error occurred, and the Output window
displays messages about the error.
d. SAS stops processing the step in which the error occurred, and the SAS log displays
messages about the error
a - Answers -What is the default length of the variable BALANCE?
Name Balance
Andrews 123.21
Smithy 92.31
Keeley 2812.23
Cist 981.99
a. 8
b. 32
c. 0
d. 16
a - Answers -If SAS cannot interpret a syntax error, then
a. the DATA step compiles but does not execute.
b. the DATA step does not compile.
c. the DATA step compiles and executes.
d. the variables in the data set will all be set to missing values.
d - Answers -Which statement identifies the name of a raw data file to be read with the
fileref Jobs and specifies that the DATA step only read records 1-20?
a. infile jobs obs 20;
b. infile jobs 1-20;
, c. input jobs 1-20;
d. infile jobs obs=20;
e. input jobs obs=20;
a - Answers -What is not created in the compilation phase of the DATA step?
a. the first observations
b. the automatic variables _N_ and _ERROR_
c. the data set descriptor
d. the program data vector
d - Answers -Which of the following statements will process only the records above
where Driver is SS?
a. a or c
b.if driver=SS
c.if driver is SS
d.if driver='SS'
b - Answers -During the compilation phase, SAS checks each statement looking for
syntax errors. Which of the following is not a syntax error?
a. missing or invalid punctuation
b. improper formats and incorrect values
c. missing or misspelled keywords.
d. invalid options or variable names
c - Answers -How would you create a list report of an Excel sheet?
a.data work.new; infile xldat.'Sheet1$'; input var1 var2 var3; run; proc print
data=work.new; run;
b.proc print data=xldat; sheet = 'Sheet1'; run;
c.proc print data=xldat.'Sheet1$'n; run;
d.proc print data=xldat.'Sheet1$'; run;
d - Answers -When you run a SAS program to read in biographical information, an error
occurs from the 3rd to the 20th records due to a change of format in the DoB column.
What is the value of _ERROR_ after the 17th record is read in?
a. 0
b. 14
c. 3
d. 1
b - Answers -The DATA step will execute
