A00-231

What is the purpose or the MISSOVER option on the INFILE statement?A . It prevents SAS from loading a new record when the end of the current record is reached. B. It enables SAS to scan the input data records until the character string that is specified in the @‘character-string’...

The following SAS program is submitted: footnote1 ‘Sales Report for Last Month’; footnote2 ‘Selected Products Only’; footnote3 ‘All Regions’; footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’; run; Which footnote(s) is/are displayed in the report?A . All Products B. Sales Report for Last...

The following SAS program is submitted: data combine; prefix=’505’; middle=’6465 ‘; end=’09090’; <insert statement here>; run; Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?A . total = cat(’-’, prefix, middle, end); B. total = catx(’-’, prefix, middle, end); C. total = prefix !!’-’!! middle...

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...