Archive for August, 2009

By admin | August 10, 2009

SAS Certified Base Programmer 50 Questions (43)

The following SAS program is submitted: libname sasdata ‘SAS-data-library’; libname labdata ‘SAS-data-library’; data labdata.boston labdata.dallas(drop=city dest equipment); set sasdata.cities(keep=orig dest city price equipment); if dest=’BOS’ then output labdata.boston; else if dest=’DFW’ then output labdata.dallas; run; Which variables are output to both data sets? a. price and orig only b. city and equipment only c. city, […]

By admin | August 10, 2009

SAS Certified Base Programmer 50 Questions (42)

Assume that SAS data sets Sasdata.Products and Sasdata.Sales both contain the Prod_ID variable. Which of the following SAS DATA steps returns only exceptions or non matches? a. libname sasdata ‘SAS-data-library’; data all; merge sasdata.products sasdata.sales; by prod_id; if ins=1 or inp=1; run; b. libname sasdata ‘SAS-data-library’; data all; merge sasdata.products(in=inp) sasdata.sales(in=ins); by prod_id; if ins=1 […]

By admin | August 10, 2009

SAS Certified Base Programmer 50 Questions (41)

A raw data file is listed below. 1—+—-10—+—-20—+— 01/05/1989 Frank 11 12/25/1987 June 13 01/05/1991 Sally 9 The following SAS program is submitted using the raw data file as input: data work.family; infile ‘file-specification’; input @1 date_of_birth mmddyy10. @15 first_name $5. @25 age 3; run; proc print data=work.family noobs; run; Which one of the following […]

By admin | August 10, 2009

SAS Certified Base Programmer 50 Questions (40)

The following SAS program is submitted: data work.test; set sasuser.class; array t{3} <insert text here> (5, 10, 15); run; Which one of the following completes the ARRAY statement and creates data elements that are not included in the SAS data set Work.Test? a. _DROP_ b. _TEMP_ c. _TEMPORARY_ d. No extra text is needed.

By admin | August 10, 2009

SAS Certified Base Programmer 50 Questions (39)

An HTML file contains a SAS report. Which ODS statement option is used to specify the name of the HTML file? a. OUT= b. FILE= c. HTML= d. HTMLFILE=