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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!