A00-231 exam

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

The following SAS program is submitted: proc sort data = work.employee; by descending fname; proc sort data = work.salary; by descending fname; data work.empdata; merge work.employee work.salary; by fname; run; Why does the program rail to execute?A . The SORT procedures contain invalid syntax. B. The merged data sets are...

Given the SAS data set WORK.TEMPS: The following program is submitted: Which output is correct? A . Option A B. Option B C. Option C D. Option DView AnswerAnswer: C

The following SAS program is submitted; data combine; country = ‘Italy, Russia, ireland’; found = find(country, ‘i’); run; What is the value of the variable FOUND in the output data set?A . 1 B. 12 C. Italy D. RussiaView AnswerAnswer: B