A00-211 exam

Given the SAS data set WORK.EMP_NAME: Given the SAS data set WORK.EMP_DEPT: The following program is submitted: How many observations are in data set WORK.ALL after submitting the program?A . 1 B. 2 C. 3 D. 5View AnswerAnswer: B

Which is a valid LIBNAME statement?A . libname "_SAS_data_library_location_"; B. sasdata libname "_SAS_data_library_location_"; C. libname sasdata "_SAS_data_library_location_"; D. libname sasdata sas "_SAS_data_library_location_";View AnswerAnswer: C

The following SAS program is submitted: data test; set sasuser.employees; if 2 le years_service le 10 then amount = 1000; else amount = 0; amount_per_year = years_service / amount run; What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?A ....

The following SAS program is submitted: What new variables are created?A . Difcount1, Difcount2 and Difcount3 B. Diff1, Diff2 and Diff3 C. Janpt, Febpt, and Marpt D. Patients1, Patients2 and Patients3View AnswerAnswer: A

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

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

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

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

Given the following data step: After data step execution, what will data set WORK.GEO contain? A . Option A B. Option B C. Option C D. Option DView AnswerAnswer: A