QUESTION: 49

The SAS data set ONE contains the variables X,Y,Z and W.

The following SAS program is submitted:
Proc transpose data =one
Out=trans
Name=new;
By x;
var y;
run;

What are the names of all of the columns created by the TRANSPOSE procedure?

new, X,Y and _COL1_
new, X and COL1 only
new, Y and COL1 only
new, X and Y only

Answer(s): B

Reveal Solution Next Question

QUESTION: 50

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

CHECK
NOT NULL
PRIMARY KEY
UNIQUE

Answer(s): A

Reveal Solution Next Question

QUESTION: 51

The following SAS program is submitted:

%let test=one;
%let one=two;
%let two=three;
%let three=last;
%put what displays is &&&&&test;

What is the written to the SAS log?

What displays is three
What displays is two
What displays is one
What displays is last

Answer(s): B

Reveal Solution Next Question

QUESTION: 52

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)?

The variables named POINTS10, POINTS15,POINTS20,POINTS25,POINTS30, POINTS35 are created in the PDV
No variables are created in the PDV
The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV
The variables named POINTS11, POINTS12, POINTS13, POINTS21, POINTS22, POINTS23 are created in the PDV

Answer(s): C

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 13)

QUESTION: 49

QUESTION: 50

QUESTION: 51

QUESTION: 52