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 […]

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. […]

By admin | August 17, 2009

SAS Certified Adv Programmer 50 Questions (31)

Which one of the following statements is true regarding the TRANSPOSE procedure? a. The TRANSPOSE procedure produces printed output by default. b. The TRANSPOSE procedure rearranges all variables by default. c. The TRANSPOSE procedure does not create an output data set by default. d. The TRANSPOSE procedure creates one observation for each restructured variable for […]

By admin | August 16, 2009

SAS Certified Adv Programmer 50 Questions (30)

When using the KEY= option in the SET statement in the DATA step, which one of the following is the purpose of the automatic variable _IORC_? a. to determine the amount of I/O usage b. to determine the success of the I/O operation c. to determine the length of the master observation d. to determine […]

By admin | August 16, 2009

SAS Certified Adv Programmer 50 Questions (29)

Given the following SAS log: 55 %let lib = sasuser.; 56 %let dsn = class; 57 %put dsn is &dsn, and lib is &lib; dsn is class, and lib is sasuser. 58 <insert statement here> 59 %put dsn is &dsn, and lib is &lib; WARNING: Apparent symbolic reference DSN not resolved. dsn is &dsn, and […]