Passed Exam Today A00-212

SAS Advanced Programming Questions and Answers

Question 25

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

OBS=pointobs

POINT=pointobs

KEY=pointobs

NOBS=pointobs

Question 26

Which one of the following is the purpose of the IDXNAME= data set option?

It instructs SAS to name and store a specific index.

It instructs SAS to store an index in a particular location.

It instructs SAS to use a specific index for WHERE processing.

It instructs SAS to use any available index for WHERE processing.

Question 27

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?

proc sql;

show testdata.one;

quit;

proc sql;

describe testdata.one;

quit;

proc sql;

show table testdata.one;

quit;

proc sql;

describe table testdata.one;

quit;