By admin | August 20, 2009

SAS Certified Adv Programmer 50 Questions (36)

By default, in which one of the following SAS catalogs are user-defined formats stored?

a. Work.Format
b. Work.Formats
c. Sasuser.Format
d. Sasuser.Formats

By admin | August 17, 2009

SAS Certified Adv Programmer 50 Questions (35)

Which one of the following programs creates a SAS data view named Sasuser.Ranch?

a.

data _null_ view=sasuser.ranch;
    set sasuser.houses;
    where style='RANCH';
run;

b.

data _null_ / view=sasuser.ranch;
    set sasuser.houses;
    where style='RANCH';
run;

c.

data sasuser.ranch view=sasuser.ranch;
    set sasuser.houses;
    where style='RANCH';
run;

d.

data sasuser.ranch / view=sasuser.ranch;
    set sasuser.houses;
    where style='RANCH';
run;

By admin | August 17, 2009

SAS Certified Adv Programmer 50 Questions (34)

Which one of the following statements is true regarding the use of a SAS numeric variable of less than 8 bytes?

a. It requires no additional processing when reading the SAS data set.
b. It might reduce the precision when the value is written to the SAS data set.
c. It has an effect on how the values are stored in the program data vector (PDV).
d. It has no effect on the precision of the largest number that can be accurately stored.

By admin | August 17, 2009

SAS Certified Adv Programmer 50 Questions (33)

Which one of the following statements is true regarding compressed SAS data sets?

a. Deleted observation space is reused by default.
b. Observations are addressable by observation number.
c. More input operations are necessary to read from the data set during processing.
d. More disk space is usually required to store compressed data sets than to store uncompressed data sets.

By admin | August 17, 2009

SAS Certified Adv Programmer 50 Questions (32)

Which one of the following is true with respect to when a DATA step with a MERGE statement successfully combines data in SAS?

a. when the data sources are indexed SAS data sets
b. when the data sources are unsorted raw data files
c. when the data sources are unsorted, unindexed SAS data sets
d. when not all the data sources contain the same BY variable(s)