Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Statisitcs

Authors: Barry Monk

2nd edition

1259345297, 978-0077836351, 77836359, 978-1259295911, 1259295915, 978-1259292484, 1259292487, 978-1259345296

More Books

Students also viewed these Mathematics questions