A00-211

A user-defined format has been created using the FORMAT procedure. Where is it stored?A . in a SAS catalog B. in an external binary file C. in a SAS dataset in the WORK library D. in a SAS dataset in a permanent SAS data libraryView AnswerAnswer: A

The following SAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?A . 0 B....

The following SAS program is submitted: How many observations are written to the WORK.SALES data set?A . 0 B. 1 C. 5 D. 60View AnswerAnswer: B

The following SAS program is submitted: libname temp ‘SAS data library’; data temp.sales; merge temp.sales work.receipt; by names; run; The input data files are sorted by the NAMES variable: What is the result?A . The program executes successfully and a temporary SAS data set is created. B. The program executes...

Given the raw data file AMOUNT: ----I---- 10---I----20---I----30 $1,234 The following SAS program is submitted: data test; infile ‘amount’; input@1 salary 6.; if_error_then description = ‘Problems’; else description = ‘No Problems’; run; What is the result?A . The value of the DESCRIPTION variable is No Probl. B. The value of...

Given the contents of the raw data file TYPECOLOR: ----I----10---I----20---I----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 colordaisygreen B. type colordaisy ellow C. type colordaisyyellow” “(missing character value) 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 ....

The following SAS program is submitted: data one; date = ‘04juI2005’d; format date weekdate.; run; proc print data = one; run; What output is generated?A . Obs date 1 Monday, July 4, 2005 B. Obs date 1 July4, 2005 C. Obs date 1 04Jul2005 D. Obs date 1 Monday, 07/04/2005View...

Which ODS statement option terminates output being written to an HTML rile?A . END B. QUIT C. STOP D. CLOSEView AnswerAnswer: D

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