Archive for September, 2009
SAS Certified Base Programmer 123 Questions (18)
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE fname age Bruce 30 Dan 40 WORK.SALARY fname salary Bruce 25000 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata; merge work.employee work.salary; by fname; totsal+ salary; run; How many variables are output to the WORK.EMPDATA data set? A. 3 B. […]
SAS Certified Base Programmer 123 Questions (17)
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below: EMPLOYEE name age Bruce 30 Dan 35 EMPLOYEE SALARY name salary Bruce 40000 Bruce 35000 Dan 37000 Dan . The following SAS program is submitted: data work.empsalary; merge work.employee (in = inemp) work.salary(in = insal); by name; if inemp and insal; […]
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 […]