Quiz Results for Certification Practice Exam

Quiz Results for Certification Practice Exam - Quiz Results...

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

View Full Document Right Arrow Icon
Quiz Results for Certification Practice Exam http://www.sas.com/apps/OLTRN/61030/m0001/base9quizx.htm 1 of 33 9/26/2007 3:26 PM Quiz Score: 0% You answered 0 out of 50 questions correctly. To see any answer, scroll down or click a question in the grid below. When you select links on this page, the information appears in the original browser window. Question # 1 2 3 4 5 6 7 8 9 10 Correct / Incorrect 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 1. 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?
Background image of page 1

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

View Full Document Right Arrow Icon
Quiz Results for Certification Practice Exam http://www.sas.com/apps/OLTRN/61030/m0001/base9quizx.htm 2 of 33 9/26/2007 3:26 PM 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 . Correct answer: c Your answer: The output for Work.Family does not have the expected data values. The values for the variable Age are missing because the program contains an invalid informat for Age . The informat for reading standard numeric data is w.d , so the correct informat for Age is 3. . The informat for Date_of_birth , mmddyy10. , is correct. You can learn about the w.d informat in Reading Raw Data in Fixed Fields the mmddyy10. informat in Reading Date and Time Values . 2. 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 Correct answer: c Your answer: Name and Department are created as character variables because they both use the $w. informat . If the second line of the INPUT statement was @15 date date9. , then the program would create one numeric variable named Date . However, the period is missing from the informat date9. . Therefore, SAS interprets the line as list input rather than formatted input, and creates two numeric variables: Date and Date9 . You can learn about the $w. informat and list input in Reading Free-Format Data the date9. informat in Reading Date and Time Values list input in Reading Free-Format Data .
Background image of page 2
Quiz Results for Certification Practice Exam http://www.sas.com/apps/OLTRN/61030/m0001/base9quizx.htm 3 of 33 9/26/2007 3:26 PM 3. What is the function of the FILENAME statement in SAS? a.
Background image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 33

Quiz Results for Certification Practice Exam - Quiz Results...

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

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