Examen Sas Base

T

estpassportQ&A

The safer , easier way to help you pass any IT exams.

Exam

: A00-211

Title

: SAS Base Programming for SAS 9

Version : V8.02

1 / 65

The safer , easier way to help you pass any IT exams.

1. The following SAS program is submitted: data work.flights; destination = 'CPH'; select(destination); when('LHR') city = 'London'; when('FRA') city = 'Frankfurt'; otherwise; end; run;What are the length and value of the CITY variable? A.length of 6, value of CPH B.length of 9, value of CPH C.length of 6, value of ' ' (missing character value) D.length of 9, value of ' ' (missing character value) Answer: C

2. Given the SAS data set SASUSER.HOUSES:

The following SAS program is submitted: The following output is desired: style price CONDO $79,700 TWOSTORY $62,550 Which DEFINEstatement completes the program and produces the desired output? A.define style / width = 9; B.define style / order width = 9; C.define style / group width = 9; D.define style / display width = 9;
2 / 65

The safer , easier way to help you pass any IT exams.

Answer:

C

3. The following SAS program is submitted: libname temp 'SAS data library'; data work.new; set temp.jobs; format newdatemmddyy10.; mdate = month(newdate); ddate = weekday(newdate); run; proc print data = work.new; run; The variable NEWDATE contains the SAS date value for April 15, 2005. What output is produced if April 15, 2005 falls on a Friday? A.Obs newdate mdate ddate 1 04/15/2005 APR 6 B.Obs newdate mdate ddate 1 04/15/2005 4 6 C.Obs newdate mdate ddate 1 04/15/2005 APR 7 D.Obs newdate mdate ddate 1 04/15/2005 4 7Answer: B

4. The following SAS program is submitted: data work.sets; do until (prod gt 6); prod + 1; end; run; What is the value of the variable PROD in the output data set? A.6 B.7 C.8 D.. (missing numeric) Answer: B

3 / 65

The safer , easier way to help you pass any IT exams.

5. What is the purpose of the END= option on the INFILE statement? A.It identifies the last record read in a raw datafile. B.It identifies the last DATA step statement to be executed. C.It identifies the length of the record that is being processed. D.It moves the end of record marker to the length specified by the logical record length. Answer: A

6. Given the SAS data set ONE: ONE XY Z 1 A 27 1A 33 1 B45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91 The following SAS program is submitted: data two; set one; by x y; iffirst.y; run; proc print data = two noobs; run; Which report is produced? A.X Y Z 1 A 27 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91

4 / 65

The safer , easier way to help you pass any IT exams.

B.X Y Z 1 A 33 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91 C.X Y Z 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91 D.The PRINT procedure fails because the data set TWO is not created in the DATA step. Answer: A7. Given the raw data file YEARAMT: ----|----10---|----20---|----30 1901 2 1905 1 1910 6 1925 . 1941 1 The following SAS program is submitted: data coins; infile 'yearamt'; input year quantity; totquantity = totquantity + quantity; run; What is the value of the variable TOTQUANTITY in the second observation? A.0 B.1 C.3

5 / 65

The safer , easier way to help you pass any IT exams.

D.. (missingnumeric) Answer: D

8. Given the contents of the raw data file PRODUCT: ----|----10---|----20---|----30 24613 $25.31 The following SAS program is submitted: data inventory; infile 'product'; input idnum 5. @10 price; run; What is the value of the PRICE variable? A.25.31 B.$25.31 C.. (missing numeric value) D.No value is stored. Answer: C

9. Given the contents of the raw data file TYPECOLOR:----|----10---|----20---|----30 daisyyellow The following SAS program is submitted: data flowers; infile 'typecolor'; input type $ 1-5 +1 color $;run; What are the values of the variables TYPE and COLOR? A.type color daisyyellow B.type color daisyellow C.type color daisyyellow" " (missing character value) D.No values are stored for the TYPE and COLOR variables. Answer: B

10. The following SAS program...