By admin | August 31, 2009

SAS Certified Base Programmer 123 Questions (13)

A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,”$64,000″ SPLIT,1190,1,1,Rand Street,”$65,850″ CONDO,1400,2,1.5,Market Street,”80,050″ TWOSTORY,1810,4,3,Garris Street,”$107,250″ RANCH,1500,3,3,Kemble Avenue,”$86,650″ SPLIT,1615,4,3,West Drive,”94,450″ SPLIT,1305,3,1.5,Graham Avenue,”$73,650″ The following SAS program is submitted using the raw data file as input: data work.condo_ranch; infile’file-specification’ dsd; input style $ @; if style = ‘CONDO’ or style = ‘RANCH’ then input sqfeet bedrooms baths […]

By admin | August 31, 2009

SAS Certified Base Programmer 123 Questions (12)

The contents of the raw data file FURNITURE are listed below: —-|—-10—|—-20—|—-30 chair,,table chair,couch,table The following SAS program is submitted: data stock; infile ‘furniture’ dsd; input item1 $ item2 $ item3 $; run; Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set? […]

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