SAS Proc Transpose Help

PROC Transpose - Homework Due 38 112015 E: 1.. ) Exercises If you restarted your SAS session since the last exercise, open and submit the Iibuume.sas program found in the data folder. 1. Rotating a Data Set The data set oriou.orders_midyear contains an observation for each customer, with the total retail value of the customer's monthly orders for the rst half of the year. Partial Listing of orion.orders_midyear (24 Total Observations) Obs Customer_ID Mont h1 Montha Months Month-1 Month5 Months 1 5 213.10 . 4?3.0 525.30 304.35 191.?9 2 10 188.10 414.09 23?5.9 3104.59 2373.44 109.29 3 11 T8.20 . . . . Y0.38 4 12 135.50 . 11?.5 129.35 07.02 122.04 5 18 . . 29.4 32.34 24.20 a. Rotate oriou.orders_midyear using PROC TRANSPOSE to create an output data set, sixmouths, containing one observation per month for each customer. 0 The data set should contain Customer_ID, Month, and Sales. 0 Do not output an observation if the monthly total is missing. I}. Print the new data set. Verify the results. Partial PROC PRINT Output (88 Total Observations) Obs Customer_ID Month Sales 1 5 1 213.10 2 5 3 4?3.00 3 5 4 525.80 4 5 5 394.35 5 5 5 191.?9 2. Rotating a Data Set the Other Direction in. Take the resulting dataset from #1 and use PROC TRANSPOSE to rotate the data back the other direction