Using SAS, answer the following Question.

5. The amount of rain for three months (June, July, and August) was recorded for each of three cities. Using the data in the following table, create a SAS data set (RAIN) containing the variables CITY, RAIN_JUNE, RAIN_JULY, and RAIN_AUGUST. RAIN_JUNE RAIN_JULYRAIN_AUGUST CITY Trenton Newark Albany 25 27 21 30 23 18 27 a. Create four additional variables in this data set: AVERAGE. PERCENT_JUNE, PERCENT_JULY, and PERCENT_AUGUST. AVERAGE is the average of the rain for the three months. Each of the PERCENT variables is computed as rainfall for the month as a percent of the AVERAGE. For example, PERCENT_JUNE would be 23 26 100x Report the results. b. Provide a listing of the data set in alphabetical order of CITY, with CITY as the ID variable c. Compute the mean, standard deviation, and the 95% confidence interval for the three RAIN variables (with all statistics printed with two decimal places) 5. The amount of rain for three months (June, July, and August) was recorded for each of three cities. Using the data in the following table, create a SAS data set (RAIN) containing the variables CITY, RAIN_JUNE, RAIN_JULY, and RAIN_AUGUST. RAIN_JUNE RAIN_JULYRAIN_AUGUST CITY Trenton Newark Albany 25 27 21 30 23 18 27 a. Create four additional variables in this data set: AVERAGE. PERCENT_JUNE, PERCENT_JULY, and PERCENT_AUGUST. AVERAGE is the average of the rain for the three months. Each of the PERCENT variables is computed as rainfall for the month as a percent of the AVERAGE. For example, PERCENT_JUNE would be 23 26 100x Report the results. b. Provide a listing of the data set in alphabetical order of CITY, with CITY as the ID variable c. Compute the mean, standard deviation, and the 95% confidence interval for the three RAIN variables (with all statistics printed with two decimal places)