A00-231

The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode='Job Description'; run; Which statement is true about the output dataset?A . The label of the variable Jobcode is Job (only the first word). B. The label of the variable Jobcode is Job Desc (only the first 8 characters)....

Given the SAS data set ONE: Given the SAS data set WORK.ONE: The following SAS program is submitted: Which report is produced? A . Option A B. Option B C. Option C D. Option DView AnswerAnswer: B

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

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”. Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?A . proc print data = sasuser.houses; label price = “Sale Price”; run; B. proc...

Given the SAS data set AGES: AGES AGE --------- The variable AGE contains character values. The following SAS program is submitted: data subset; set ages; where age> 12; run; How many observations are written out to the data set SUBSET?A . 0 B. 1 C. 2 D. 3View AnswerAnswer: A

The following SAS program is submitted: The program fails execution due to syntax errors. What is the cause of the syntax error?A . The variable MONTHSALES does not exist. B. An array cannot be referenced on a KEEP data set option. C. The KEEP= data set option should be (KEEP...

Given the SAS data set WORKAWARDS: WORK.AWARDS FNAMEPOINTSMONTH ---------------------------------- Amy24 Amy17 Gerard33 Wang33 Wang112 Wang18 The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run; How are the observations sorted?A . ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17 B. ENAME POINTS MONTH...

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 work.sets; do until (prod gt 6); prod + 1; end; run; What is the value of the variable PROD in the output data set?A . 6 B. 7 C. 8 D. (missing numeric)View AnswerAnswer: B

The following SAS program is submitted: data work.retail; cost = ‘20000’; total= .10* cost run; What is the result?A . The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log. B. The value of the variable TOTAL in the...