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

The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE?

A. data two; set three; set one key = X; run;

B. data two; set three key = X; set one; run;

C. data two; set one; set three key = X; run;

D. data two; set three; set one (key = X); run;

The following SAS program is submitted:

%macro test(var);

proc print data = sasuser.class;

where age > andvar;

run;

%mend;

Which type of parameter is the macro variable VAR?

A. default

B. keyword

C. positional

D. command

Given the data set SASHELP.CLASS:

The following SAS program is submitted:

The PROC steps execute successfully?

A. PROC PRINT only

B. PROC MEANS and PROC PRINT

C. PROC MEANS only

D. No PROC steps execute successfully

Which one of the following options is available for SAS macro debugging?

A. MLOGIC

B. MDEBUG

C. MSGLEVEL

D. MAUTOSOURCE

Given the two output sets shown on the left, which program produced the output shown on the right?

A. Option A

B. Option B

C. Option C

D. Option D

The following SAS program is submitted:

data two;

y = '2';

run;

%let x = 10;

%let var = y;

data one;

set two (keep = andvar);

z = andvar * andx;

run;

Which one of the following is the value of the variable Z when the program finishes execution?

A. _ERROR_

B. 20 (as a numeric)

C. 20 (as a character)

D. . (missing numeric)

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

The following SAS program is submitted:

%let first=yourname;

%let last=first;

%put andandandlast;

What is written to the SAS Log?

A. First

B. Yourname

C. andandFirst

D. andyourname

In the data step merge, the BY variables in all data sets must have the same:

A. Name and length

B. Name, type, and length

C. Name and type

D. Name