By admin | August 31, 2009

SAS Certified Base Programmer 123 Questions (11)

The following SAS program is submitted and reads 100 records from a raw data file: data work.total; infile ‘file-specification’ end = eof; input name $ salary; totsal+ salary; <insert IF statement here> run; Which one of the following IF statements writes the last observation to the output data set? A. if end = 0; B. […]

By admin | August 31, 2009

SAS Certified Base Programmer 123 Questions (10)

The following SAS program is submitted: libname rawdata1 ‘location of SAS data library’; filename rawdata2 ‘location of raw data file’; data work.testdata; infile <insert item here> input sales1 salse2; run; Which one of the following is needed to complete the program correctly? A. rawdata1 B. rawdata2 C. ‘rawdata1’ D. ‘rawdata2’

By admin | August 31, 2009

SAS Certified Base Programmer 123 Questions (9)

A raw data record is listed below: —-|—-10—|—-20—|—-30 son,Travis, The following output is desired: relation firstname son Travis Which one of the following SAS programs reads the data correctly? A. data family / dlm = ‘,’; infile ‘file-specification’; input relation $ firstname $; run; B. option dlm = ‘,’; data family; infile ‘file-specification’; input relation […]

By admin | August 28, 2009

SAS Certified Base Programmer 123 Questions (8)

The contents of the raw data file TYPECOLOR are listed below: —-|—-10—|—-20—|—-30 daisyyellow The following SAS program is submitted: data flowers; infile’typecolor’; input type $ 1-5 +1 color $; run; Which one of the following represents the values of the variables TYPE and COLOR? A. type color daisy yellow B. type color daisy ellow C. […]

By admin | August 28, 2009

SAS Certified Base Programmer 123 Questions (7)

The contents of the raw data file PRODUCT are listed below: —-|—-10—|—-20—|—-30 24613 $25.31 The following SAS program is submitted: data inventory; infile ‘product’; input idnum 5. @10 price; run; Which one of the following is the value of the PRICE variable? A. 25.31 B. $25.31 C. . (missing numeric value) D. No value is […]