SAS Institute A00-212 Exam Questions & Answers

This question will ask you to provide a segment of missing code.

Given data sets ONE and TWO with the same variables, the following SAS program is submitted:

In the text below, complete the following program so that it will produce the same results as the above program:

Case is ignored and standard SAS syntax rules apply.

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

A. andRC

B. andERR

C. andSYSRC

D. andSYSERR

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; merge one two; by num; run;

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

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;