SAS Certification Practice Exam_ Base Programming

SAS Certification Practice Exam_ Base Programming - SAS...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
SAS Certification Practice Exam: Base Programming http://www.sas.com/apps/OLTRN/61030/m0001/base9quiz.htm 1 of 17 9/26/2007 3:15 PM SAS ® Certification Practice Exam: Base Programming for SAS ® 9 Certification Practice Exam You should read the introductory material before you take this practice exam. Select the best answer for each question and click Score My Practice Exam. 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 this 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; The following output is generated for the Work.Family data set: Date_of_birth First_name Age 10597 Frank . 10220 June . 11327 Sally . Which of the following statements is true regarding the Work.Family output? a. The output has the expected data values. b. The output does not have the expected data values due to an invalid data set name. c. The output does not have the expected data values due to an invalid informat for Age only. d. The output does not have the expected data values due to invalid informats for both Age and Date_of_birth . 1. The following SAS program is submitted: data employees; infile 'file-specification' ; input @1 name $10. @15 date date9 @25 department $; run; How many numeric variables are created? a. 0 b. 1 c. 2 d. 3 2.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
http://www.sas.com/apps/OLTRN/61030/m0001/base9quiz.htm 2 of 17 9/26/2007 3:15 PM What is the function of the FILENAME statement in SAS? a. It associates a file reference with an external file. b. It associates a library reference with an external file. c. It associates a file reference with a relational database. d. It associates a library reference with a relational database. 3. A raw data file is listed below. 1---+--- - 10---+----20---+--- Jose,47,210 Sue,,108 The following SAS program is submitted using this file as input: data employeestats; < insert INFILE statement here >; input name $ age weight; run; The following output is desired: name age weight Jose 47 210 Sue . 108 Which of the following INFILE statements completes the program and accesses the data correctly? a. infile ' file-specification ' pad; b. infile ' file-specification ' dsd; c. infile ' file-specification' missover; d. infile ' file-specification ' dlm=','; 4. A raw data file is listed below. 1---+--- - 10---+----20---+--- RANCH,1250,10MAR2004 SPLIT,1190,10/20/2004 CONDO,1400,17JUN2004 TWOSTORY,1810,12/31/2004 RANCH,1500,20JAN2004 SPLIT,1615,08/19/2004 The following SAS program is submitted using this file as input: data work.condo_ranch; infile ' file-specification ' dsd; input style $ @; if style = 'CONDO' or style = 'RANCH' then input sqfeet saledate : date9.; else input sqfeet saledate : mmddyy10.; run; How many observations does the Work.Condo_ranch data set contain? a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 17

SAS Certification Practice Exam_ Base Programming - SAS...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online