Question: Level 1 3. Converting Observations to Variables The data set orion.orders_qtr1 contains an observation for each customer, with the customer's first quarter orders by month.

Level 1 3. Converting Observations to Variables The data set orion.orders_qtr1 contains an observation for each customer, with the customer's first quarter orders by month. Partial orion.orders_qtr1 (37 Total Observations) Obs Customer_ID Month1 Month2 Month3 5 213 . 10 478.0 10 188 . 10 414.09 2876.9 11 78. 20 12 135 . 60 117.6 a. Use PROC TRANSPOSE to create an output data set containing multiple observations for each customer. . Name the new data set qtrl. . Name the new variables Customer_ID, Month, and Sale_Amt as shown below. b. Print the new data set and verify your results. Partial PROC PRINT Output (111 Total Observations) Obs Customer_ID Month Sale Amt Monthi 213. 10 5 Month2 5 Month3 478.00 10 Month1 188. 10 10 Month2 414.09
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
