Given the following SAS data sets ONE and TWO:

ONE TWO

YEAR QTR BUDGET YEAR QTR SALES

------------------------------ ---------------------------- 2001 3 500 2001 4 300

2001 4 400 2002 1 600

2002 1 700

The following SAS program is submitted:

proc sql;

select one.*, sales

from one, two;

quit;

Which one of the following reports is generated?

A. YEAR QTR BUDGET SALES

2001 4 400 300

2002 1 700 600

B. YEAR QTR BUDGET SALES

2001 3 500 .

2001 4 400 300

2002 1 700 600

C. YEAR QTR BUDGET SALES

2001 3 500 300

2001 4 400 300

2002 1 700 600

D. YEAR QTR BUDGET SALES

2001 3 500 300

2001 4 400 300

2002 1 700 300

2001 3 500 600

2001 4 400 600

2002 1 700 600

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

A. NODUP

B. UNIQUE

C. DISTINCT

D. NODUPKEY

The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ;

Which one of the following is the maximum number of elements stored?

A. 3

B. 7

C. 8

D. 11

The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES

OBS STYLE

1 RANCH

2 SPLIT

3 CONDO

4 TWOSTORY

5 RANCH

6 SPLIT

7 SPLIT

The following SAS program is submitted:

proc sql noprint;

select distinct style

into :styles separated by ' '

from sasuser.houses

order by style;

quit;

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

A. CONDO RANCH SPLIT TWOSTORY

B. RANCH SPLIT CONDO TWOSTORY

C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY

D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

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.