A00-212 Online Practice Questions and Answers

Which one of the following is true regarding the KEEP statement?

A. The KEEP statement is available in both the DATA and the PROC steps.

B. The KEEP statement selects the variables read from the input data set(s).

C. The KEEP statement applies to all data sets created within the same DATA step.

D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.

Which of the following is true about the COMPRESS=YES data set option?

A. It is most effective with numeric data that represents large numeric values

B. It is most effective with character data that contains patterns, rather than simple repetitions

C. It uses the Ross Data Compression method to compress numeric data

D. It is most effective with character data that contains repeated characters

This question will ask you to provide a segment of missing code.

Given the SAS data set WORK EXAM:

TotalScore

*

The following SAS program is submitted:

The following output is desired:

TotalScore

Which WHERE expression completes the program and generates the desired output?

A. Where TotalScore is not missing

B. Where TotalScore ne null

C. Where TotalScore is not

D. Where TotalScore ne missing

Which PUT statements will be the log if the program is submitted at the beginning of a new SAS session?

A. Option A

B. Option B

C. Option C

D. Option D

The following SAS program is submitted:

%let value = 9;

%let value2 = 5;

%let newval = %eval(andvalue / andvalue2);

Which one of the following is the resulting value of the macro variable NEWVAL?

A. 1

B. 2

C. 1.8

D. null

The following SAS program is submitted:

%micro test(var);

%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;

%let type=%index(andjobs, andvar);

%put type = andtype;

%mend;

%test(SMITH)

What is the value of the macro variable TYPE when the %PUT statement executes?

A. 0

B. Null

C. 6

D. 3

Given the following partial SAS log:

Which SQL procedure statement generated this output?

A. DECREASE TABLE SASHELP.CLASS;

B. CONTENTS TABLE SASHELP.CLASS;

C. DESCRIBE TABLE=SASHELP.CLASS;

D. ATTRIBUTE TABLE=SASHELP.CLASS

Which one of the following options controls the pagesize of a SAS data set?

A. SIZE=

B. BUFNO=

C. BUFSIZE=

D. PAGESIZE=