A00-202 Online Practice Questions and Answers

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

A. SIZE=

B. BUFNO=

C. BUFSIZE=

D. PAGESIZE=

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

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 left join two

on one.year = two.year;

quit;

Which one of the following reports is generated?

A. YEAR QTR BUDGET SALES

2001 3 500 .

B. YEAR QTR BUDGET SALES

2001 4 400 300

2002 1 700 600

C. YEAR QTR BUDGET SALES

2001 3 50 .

2001 4 400 300

2002 1 700 600

D. YEAR QTR BUDGET SALES

2001 3 500 300

2001 4 400 300

2002 1 700 600

Given the following SAS data sets ONE and TWO:

ONE TWO OBS COMMON X OBS COMMON Y -------------------------- ------------------------------ 1 A 10 1 A 1 2 A 13 2 A 3 3 A 14 3 B 4 4 B 9 4 B 2 5 C 8 5 C 5 6 C 14

The following SAS DATA step is submitted: data combine; set one; set two; run; Which one of the following represents the data values stored in data set COMBINE?

A. OBS COMMON X Y

1 A 10 1

2 A 13 3

3 A 14 3

4 B 9 4

5 B 9 2

6 C 8 5

7 C 14 5

B. OBS COMMON X Y

1 A 10 1

2 A 13 3

3 B 9 4

4 C 8

C. OBS COMMON X Y

1 A 10 1

2 A 13 3

3 B 14 4

4 B 9 2

5 C 8 5

D. OBS COMMON X Y

1 A 10 1

2 A 13 1

3 A 14 1

4 A 10 3

5 A 13 3

6 A 14 3

7 B 9 4

8 B 9 2

9 C 8 5

10 C 14 5

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

The following SAS program is submitted:

data temp;

array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1}

run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

A. 10

B. 20

C. 30

D. 40

The following SAS program is submitted:

%let first = yourname;

%let last = first;

%put andandandlast;

Which one of the following is the result in the log of the %PUT statement?

A. first

B. andfirst

C. yourname

D. andyourname

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

A. NODUP

B. UNIQUE

C. DISTINCT

D. NODUPKEY