A00-231 V1

The following SAS program is submitted: data work.flights; destination = ‘cph’; select(destination); when(’LHR’) city = ‘London’; when(’CPH’) city = ‘Copenhagen’; otherwise city = ‘Other’; end; run; What is the value of the CITY variable?A . OtherB . CopenhC . CopenhagenD . ‘‘(missing character value)View AnswerAnswer: A

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

Given the following code: proc print data=SASHELP.CLASS(firstobs=5 obs=15); where Sex='M'; run; How many observations will be displayed?A . 11B . 15C . 10 or fewerD . 11 or fewerView AnswerAnswer: D

The following code was modified to generate the results further below: proc format; value agegrp low-12 ='Pre-Teen' 13-high = 'Teen'; run; proc means data=SASHELP.CLASS; var Height; class Sex Age; format Age agegrp.; run; The following results were generated to display only specific statistics and limit the decimals with the modification:...

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 . 0B . 1C . 5D . 60View AnswerAnswer: D

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, 2005B . Obs date 1 July4, 2005C . Obs date 1 04Jul2005D . Obs date 1 Monday, 07/04/2005View...

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 . 1B . 2C . 3D . 5View AnswerAnswer: B