A00-231

Read the table: Given the SAS data set SASUSER.HOUSES: Obsstylebedroomsbathspricesqteetstreet 1CONDO21.5800501200MAIN 2CONDO32.5793501300ELM 3CONDO42.51271501400OAK 4CONDO22.01107001100FIFTH 5TWOSTORY43.01072502100SECOND 6TWOSTORY21.0556501600WEST 7TWOSTORY21.0692501450NORTH 6TWOSTORY42.5102950 2000SOUTH The following SAS program is submitted: proc report data = sasuser.houses nowd headline; column style price; where price It 100000; <insert DEFINE statement here> define price / mean width = 9...

The following SAS program is submitted: proc format value score 1 - 50 = ‘Fail’ 51 - 100 = ‘Pass’; run; proc report data = work.courses nowd; column exam; define exam / display format = score.; run; The variable EXAM has a value of 50.5. How will the EXAM variable...

The following SAS program is submitted: libname temp ‘SAS data library’; data work.new; set temp.jobs; format newdate mmddw10.; 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,...

Which program displays a listing of all data sets in the SASUSER library?A . proc contents lib = sasuser.all; run; B. proc contents data = sasuser.all; run; C. proc contents lib = sasuser._alI_; run; D. proc contents data = sasuser._all_; run;View AnswerAnswer: D

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

Given the contents of the raw data file EMPLOYEE: ----|----10----|----20----|----30 Alan 19/2/2004 ACCT Rob 22/5/2004 MKTG MaryJane 14/3/2004 EDUC The following SAS program is submitted: data emps; infile ‘employee’; input@1 name$ @15 date <insert INFORMAT here> @25 department$; run; Which INFORMAT correctly completes the program?A . date9. B. ddmmyyyy9. C....

The following SAS program is submittad: data work.sales; do year = 1 to 5; do month=1 to 12; x+1; output end; end; run; How many observations are written the WORK SALES data set?A . 0 B. 1 C. 5 D. 60View AnswerAnswer: D

1941 1 The following SAS program is submitted: data coins; infile ‘yearamt’; input year quantity; <insert statement(s) here> run; Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?A . totquantity + quantity; B. totquantity = sum(totquantity...

The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?A . format salary comma11.2; B. format salary dollar8.2; C. format salary dollar11.2; D. format salary comma8.2 dollar8.2;View AnswerAnswer: C