A00-231 exam

The following SAS program is submitted: data work.flights; destination = ‘cph’; select(destination); when(’LHR’) city = ‘London’; when(’CPH’) city = ‘Copenhagen’; otherwise city = ‘Other’; end; run; What is the value of the CITY variable?A . Other B. Copenh C. Copenhagen D. ‘‘(missing character value)View AnswerAnswer: A

Given the raw data record DEPT: ----|----10---|----20---|----30 Printing 750 The following SAS program is submitted: data bonus; infile ‘dept’; inputdept$ 1-11 number 13- 15; <insert statement here> run; Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?A . department = dept II...

Given the raw data file EMPLOYEE: ----I----1 0---I----20---I----30 Ruth 39 11 Jose 32 22 Sue 30 33 John 40 44 The following SAS program is submitted: data test; infile ‘employee’; input employee_name $ 1-4; if employee_name = ‘Ruth’ then input idnum 10-11; else input age 7-8; run; What value does...

The following SAS program is submitted: data WORK.DATE_INFO; X="01Jan1960" D; run; What variable X contains what value?A . the numeric value 0 B. the character value "01Jan1960" C. the date value 01011960 D. the code contains a syntax error and does not execute.View AnswerAnswer: A

The following output is created by the FREQUENCY procedure: Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?A . norowcount nocolcount B. freq percent C. norow nocol D. nocountsView AnswerAnswer: C

Given the following code: proc print data=SASHELP.CLASS(firstobs=5 obs=15); where Sex='M'; run; How many observations will be displayed?A . 11 B. 15 C. 10 or fewer D. 11 or fewerView AnswerAnswer: D

The SAS data set PETS is sorted by the variables TYPE and BREED. The following SAS program is submitted: proc print data = pets; var type breed; sum number; run; What is the result?A . The SUM statement produces only a grand total of NUMBER. B. The SUM statement produces...

The following SAS program is submitted: data work. new; length word $7; amount = 4; it amount = 4 then word = ‘FOUR’; else if amount = 7 then word = ‘SEVEN’; else word = ‘NONE!!!’; amount = 7; run; What are the values of the AMOUNT and WORD variables...

Which statement is true concerning the SAS automatic variable _ERROR_?A . It cannot be used in an if/then condition. B. It cannot be used in an assignment statement. C. It can be put into a keep statement or keep= option. D. It is automatically dropped.View AnswerAnswer: D

Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm. Students; file ‘file specification’; put name $15. @5 age 2.; run; What is written to the output raw data file?A ....