Given the following SAS data sets ONE and TWO:

ONE TWO

NUM COUNTRY NUM CITY

______________ ____________________________ ______ 1 CANADA 3 BERLIN

2 FRANCE 5 TOKYO

3 GERMANY 4 BELGIUM

5 JAPAN

The following SAS program is submitted:

proc sql;

select country

from one where not exists

(select * from two where one.num = two.num);

quit;

Which one of the following reports is generated?

A. COUNTRY

GERMANY

JAPAN

B. COUNTRY

FRANCE

BELGIUM

C. COUNTRY

CANADA

FRANCE

BELGIUM

D. COUNTRY

CANADA

FRANCE

GERMANY

Given the following SAS data set ONE:

ONE NUM VAR

1 A 2 B 3 C

Which one of the following SQL programs deletes the SAS data set ONE?

A. proc sql; delete table one; quit;

B. proc sql; alter table one drop num, var; quit;

C. proc sql; drop table one; quit;

D. proc sql; delete from one; quit;

Given the following SAS data sets ONE and TWO:

ONE TWO NUM CHAR1 NUM CHAR2

1 A 2 X

2 B 3 Y

4 D 5 V

The following SAS program is submitted creating the output table THREE:

data three;

set one two;

run;

THREE

NUM CHAR1 CHAR2

1 A 2 B 4 D 2 X 3 Y 5 V

Which one of the following SQL programs creates an equivalent SAS data set THREE?

A. proc sql; create table three as select * from one outer union corr select * from two; quit;

B. proc sql; create table three as select * from one outer union select * from two; quit;

C. proc sql; create table three as select * from one outer union select * quit;

D. proc sql; create table three as select * from one union corr select * from two; quit;

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

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

A. CHECK

B. UNIQUE

C. FORMAT

D. DISTINCT

Which one of the following statements is true?

A. The WHERE statement can be executed conditionally as part of an IF statement.

B. The WHERE statement selects observations before they are brought into the PDV.

C. The subsetting IF statement works on observations before they are read into the PDV.

D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

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

A. MLOGIC

B. MDEBUG

C. MSGLEVEL

D. MAUTOSOURCE

The following SAS program is submitted:

%macro execute;

proc print data = sasuser.houses;

run;

%end;

%mend;

Which of the following completes the above program so that it executes on Tuesday?

A. %if andsysday = Tuesday %then %do;

B. %if andsysday = 'Tuesday' %then %do;

C. %if "andsysday" = Tuesday %then %do;

D. %if 'andsysday' = 'Tuesday' %then %do;

Which one of the following statements about compressed SAS data sets is always true?

A. Each observation is treated as a single string of bytes.

B. Each observation occupies the same number of bytes.

C. An updated observation is stored in its original location.

D. New observations are added to the end of the SAS data set.

Given the following SAS statement: %let idcode = Prod567;

Which one of the following statements stores the value 567 in the macro variable CODENUM?

A. %let codenum = substr(andidcode,length(andidcode)-2);

B. %let codenum = substr(andidcode,length(andidcode)-3);

C. %let codenum = %substr(andidcode,%length(andidcode)-2);

D. %let codenum = %substr(andidcode,%length(andidcode)-3);