Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data set orion . discount contains information about various discounts that Orion Star runs on its products. Due to excellent sales, all discounts from

The data set orion .discount contains information about various discounts that Orion Star runs on its products.
Due to excellent sales, all discounts from December 2007 will be repeated in July 2008. Both the December 2007 and the July 2008 discounts will be called the Happy Holidays promotion.
Create a new data set named work. extended that contains all discounts for the Happy Holidays promotion.
Use a WHERE statement to read only observations with a start date of 01Dec2007.
Create a new variable, Promotion, which has the value Happy Holidays for each observation.
Create another new variable, Season, that has a value of winter for the December observations and Sumer for the July observati
July 2008 discounts should have a start date of 01 ul2008 and an end date of 31Jul2008.
Use explicit OUTPUT to write two observations for each observation read.
Print the new data set work.extended, examine the results, and answer the following questions.
How many observations are included in the new data set work.extended? Blank 1
What is the value of Unit_Sales_Price for observation 301? Blank 2
What is the value of Season for observation 207? Blank 3
What is the value of Start_date for observation 115? Blank 4
What is the value of End_date for observation 98? Blank 5
image text in transcribed

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

More Books

Students also viewed these Databases questions