A00-202 Online Practice Questions and Answers

The following SAS code is submitted:

%macro houses(dsn = houses,sub = RANCH);

data anddsn;

set sasuser.houses;

if style = "andsub";

run;

%mend;

%houses(sub = SPLIT)

%houses(dsn = ranch)

%houses(sub = TWOSTORY)

Which one of the following is the value of the automatic macro variable SYSLAST?

A. work.ranch

B. work.houses

C. WORK.RANCH

D. WORK.HOUSES

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

A. MODIFY

B. FORMAT

C. CONTENTS

D. DATASETS

Given the following SAS data set ONE:

ONE LEVEL AGE

1 10 2 20

3 20

2 10

1 10

2 30

3 10

2 20

3 30

1 10

The following SAS program is submitted:

proc sql;

select level, max(age) as MAX

from one group by level

having max(age) > (select avg(age) from one);

quit;

Which one of the following reports is generated?

A. LEVEL AGE

2 20

3 20

B. LEVEL AGE

2 30

3 30

C. LEVEL MAX

2 20

3 30

D. LEVEL MAX

2 30

3 30

The DICTIONARY.MACROS table stores information about which of the following?

A. user defined macro variables only

B. system defined macro variables only

C. both user and system defined macro variables

D. macros stored in the autocall macro library only

Given the following SAS data set named WORK.INTERNAT:

WORK.INTERNAT LOCATION SUM

USA 30

EUR 40

The following SAS program is submitted:

%let LOC = Usa;

proc sql;

select *

from internat

where location = "andLoc";

quit;

Which one of the following is the result when the above code is executed on the above data set?

A. A report is generated with one destination.

B. No report is generated as the case of the compared values is different.

C. No report is generated as the case of the macro variable name is different.

D. A report is generated with the two original observations as the where clause does not work.

The following SAS program is submitted:

proc sql;

select *

from dictionary.tables;

quit;

Which one of the following is reported?

A. metadata on all tables in all libraries

B. metadata on all tables in the WORK library only

C. metadata on all tables in the SASUSER library only

D. metadata on all tables in the DICTIONARY library only

Which one of the following should be avoided when creating and using an SQL procedure view?

A. using a HAVING clause

B. using summary functions

C. referencing a view multiple times in the same program

D. creating views on tables whose structures remain constant

Given the following SAS data set ONE:

ONE REP COST

SMITH 200

SMITH 400

JONES 100

SMITH 600

JONES 100

JONES 200

JONES 400

SMITH 800

JONES 100

JONES 300

The following SAS program is submitted:

proc sql;

select rep, avg(cost) as AVERAGE

from one

group by rep

having avg(cost) > (select avg(cost) from one);

quit;

Which one of the following reports is generated?

A. REP AVERAGE

JONES 200 B. REP AVERAGE

JONES 320

C. REP AVERAGE

SMITH 320

D. REP AVERAGE

SMITH 500

Given the following SAS data set ONE:

ONE COUNTRY CITY VISIT

USA BOSTON 10

UK LONDON 5

USA DALLAS

UK MARLOW 10

USA BOSTON 20

UK LONDON 15

USA DALLAS 10

The following SAS program is submitted:

proc sql;

select country, city, sum(visit) as TOTAL

from one group by country, city order by country, total desc; quit;

Which one of the following reports is generated?

A. COUNTRY CITY TOTAL

UK MARLOW 10

UK LONDON 20

USA BOSTON 50

USA DALLAS 20

B. COUNTRY CITY TOTAL

UK LONDON 20

UK MARLOW 10

USA BOSTON 50

USA DALLAS 20

C. COUNTRY CITY TOTAL

USA BOSTON 50

USA DALLAS 20

UK LONDON 20

UK MARLOW 10

D. COUNTRY CITY TOTAL

UK MARLOW 10

UK LONDON 20

USA DALLAS 20

USA BOSTON 50

Given the following SAS data sets ONE and TWO:

ONE TWO NUM CHAR1 NUM CHAR2

1 A1 2 X1

1 A2 2 X2

2 B1 3 Y

2 B2 5 V

4 D

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

proc sql;

create table three as

select one.num, char1, char2

from one, two

where one.num = two.num;

quit;

THREE

NUM CHAR1 CHAR2

2 B1 X1 2 B1 X2 2 B2 X1 2 B2 X2

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

A. data three; merge one two; by num; run;

B. data three; set one; set two; by num; run;

C. data three;C.data three; merge one (in = in1) two (in = in2); by num;

if in1 and in2;

run;

D. data three;D.data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;