A00-212 Online Practice Questions and Answers

The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

A. proc sql; show testdata.one; quit;

B. proc sql; describe testdata.one; quit;

C. proc sql; show table testdata.one; quit;

D. proc sql; describe table testdata.one; quit;

Which PUT statements will be the log if the program is submitted at the beginning of a new SAS session?

A. Option A

B. Option B

C. Option C

D. Option D

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 program is submitted: data new (bufsize = 6144 bufno = 4); set old; run;

Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.

B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.

D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.

The following SAS program is submitted: data temp:

array points { 2,3 } (10,15,20,25,30,35);

run;

What impact does the ARRAY statement have in the program Data vector (PDV)?

A. The variables named POINTS10, POINTS15,POINTS20,POINTS25,POINTS30, POINTS35 are created in the PDV

B. No variables are created in the PDV

C. The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV

D. The variables named POINTS11, POINTS12, POINTS13, POINTS21, POINTS22, POINTS23 are created in the PDV

Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

A. OBS=pointobs

B. POINT=pointobs

C. KEY=pointobs

D. NOBS=pointobs

Given the SAS data set WORK.ONE:

The following SAS program is submitted;

Which result set would be generated?

A. Option A

B. Option B

C. Option C

D. Option D

Given the SAS data sets: The following SAS program is submitted:

What output is produced?

A. Name

Charlie

Omar

B. Name

Omar

Nguyen

C. Name

Charlie

Nguyen

Nguyen

D. Name

Charlie

Omar

Nguyen

Following SAS program is submitted:

data temp();

infile 'rawdata';

input x $ y z;

run;

RAWDATA is a file reference to an external file that is ordered by the variable X.

Which option specifies how the data in the SAS data set TEMP will be sorted?

A. ORDEREDBY=X

B. GROUPBY=X

C. SORTEDBY=X

D. SORTSYNC=X

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