By admin | January 13, 2010

SAS Certified Adv Programmer 130 Questions (53)

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

A. It instructs SAS to name and store a specific index.
B. It instructs SAS to store an index in a particular location.
C. It instructs SAS to use a specific index for WHERE processing.
D. It instructs SAS to use any available index for WHERE processing.

By admin | January 13, 2010

SAS Certified Adv Programmer 130 Questions (52)

The following SAS program is submitted:

data temp;
    array points{2,3} _temporary_;
run;

Which one of the following is the maximum number of elements that are stored?
A. 2
B. 3
C. 5
D. 6

By admin | January 13, 2010

SAS Certified Adv Programmer 130 Questions (51)

Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

A. ECHO VIEW option
B. EXPAND VIEW option
C. VALIDATE VIEW statement
D. DESCRIBE VIEW statement

By admin | January 13, 2010

SAS Certified Adv Programmer 130 Questions (50)

Which one of the following is true regarding the KEEP statement?

A. The KEEP statement is available in both the DATA and the PROC steps
B. The KEEP statement selects the variables read from the input data set(s).
C. The KEEP statement applies to all data sets created within the same DATA step.
D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.

By admin | January 13, 2010

SAS Certified Adv Programmer 130 Questions (49)

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