SAS Certified Base Programmer 123 Questions (16)
The following SAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money(in = insal); if insal and inemp; run; The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain? A. 0 B. 5 C. 7 D. 12
SAS Certified Base Programmer 123 Questions (15)
The following SAS program is submitted: data numrecords; infile ‘file-specification’; input @1 patient $15. relative $ 16-26 @; if relative = ‘children’ then input @54 diagnosis $15. @; else if relative = ‘parents’ then input @28 doctor $15. clinic $ 44-53 @54 diagnosis $15. @; input age; run; How many raw data records are read […]
SAS Certified Base Programmer 123 Questions (14)
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’; input sqfeet bedrooms baths street […]
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 […]
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? […]