By admin | January 13, 2010

SAS Certified Adv Programmer 130 Questions (48)

Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

A. It temporarily compresses observations in a SAS data set.
B. It allows users to update the same SAS data set concurrently.
C. It allows new observations to be inserted wherever enough free space exists.
D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.

By admin | January 7, 2010

SAS Certified Adv Programmer 130 Questions (47)

The following SAS program is submitted:

options yearcutoff = 1950;
%macro y2kopt(date);
    %if &date >= 14610 %then %do;
        options yearcutoff = 2000;
    %end;
    %else %do;
        options yearcutoff = 1900;
    %end;
%mend;

data _null_;
    date = "01jan2000"d;
    call symput("date" ,left(date));
run;

%y2kopt(&date)

The SAS date for January 1, 2000 is 14610 and the SAS system option for YEARCUTOFF is set to 1920 prior to submitting the above program. Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

A. 1900
B. 1920
C. 1950
D. 2000

By admin | January 7, 2010

SAS Certified Adv Programmer 130 Questions (46)

When is it appropriate to create indexes on a SAS data set for efficient processing?

A. if small subsets of data are often retrieved
B. if the key variable has very few unique values
C. if the data are often used for BY group processing
D. if the SAS data set file page count is less than three pages

By admin | January 7, 2010

SAS Certified Adv Programmer 130 Questions (45)

The following SAS ARRAY statement is submitted:

array score{ * } a4 - a10, a25; 

Which one of the following is the maximum number of elements stored?

A. 3
B. 7
C. 8
D. 11

By admin | January 7, 2010

SAS Certified Adv Programmer 130 Questions (44)

Which one of the following options displays the value of a macro variable in the SAS log?

A. MACRO
B. SOURCE
C. SOURCE2
D. SYMBOLGEN