prices (50 Total Observations) Product_ID Unit_Price Factor 210200100009 $34. | Cheap Nursing Papers

prices (50 Total Observations) Product_ID Unit_Price Factor 210200100009 $34.

Hello I need help on how to proceed with this problem in SAS

Partial orion.prices (50 Total Observations)

    Product_ID      Unit_Price  Factor

  210200100009          $34.70    1.01

  210200100017          $40.00    1.01

  210200200023          $19.80    1.01

  210200600067          $67.00    1.01

  210200600085          $39.40    1.01

a.  Type DATA step to make a new data set that forecasts unit prices for the next three years. This data set contains three observations for each input observation read from orion.prices.

·   Open file p202e01. It reads orion.prices and creates a new data set named work.price_increase.

·   Use explicit OUTPUT statements to forecast unit prices for the next three years, using Factor as the annual rate of increase.

b.  Print the new data set.

·   Include only Product_ID, Unit_Price, and Year in the report.

·   Verify your results.

Partial PROC PRINT Output (150 Total Observations)

 Obs     Product_ID      Unit_Price   Year

  1   210200100009          $35.05     1

  2   210200100009          $35.40     2

  3   210200100009          $35.75     3

  4   210200100017          $40.40     1

5    210200100017          $40.80     2

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp