SAS Base Certification questions with correct answers

SAS Base Certification questions with
correct answers

c - correct answer ✔✔ 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 - correct answer ✔✔ 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 - correct answer ✔✔ 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 - correct answer ✔✔ Which of the following is a valid variable name?



a. _Units_

b. 2Cool

c. Total$

d. Days-To-Ship



d - correct answer ✔✔ 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 - correct answer ✔✔ 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 - correct answer ✔✔ 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 - correct answer ✔✔ 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

, c - correct answer ✔✔ Which time span is used to interpret two-digit values if the
YEARCUTOFF= option is set to 1969?



a. 1969-2000

b. 1969-2069

c. 1969-2068

d. 1870-1969

e. 1970-2069



b - correct answer ✔✔ What does the NOOBS option do in the PROC PRINT step?



a. Relentlessly mocks you for being new to SAS.

b. Removes the default Obs column from the output

c. Prints only the the column titles with no data.

d. Prints the data with no column titles.



c - correct answer ✔✔ Which statement correctly accesses an Excel file?



a.libname xldat 'C:\Excel\example.xlsx.Sheet1';

b.filename xldat 'C:\Excel\example.xlsx';

c.libname xldat 'C:\Excel\example.xlsx';

d.filename xldat 'C:\Excel\example.xlsx\Sheet1$';



j - correct answer ✔✔ The following format substitutes full names for initials. Identify the
error(s).