Question: The data set orion.orders contains information on in - store, catalog, and internet orders as well as delivery dates. Orion Star wants to study catalog

The data set orion.orders contains information on in-store, catalog, and internet orders as well as delivery dates. Orion Star wants to study catalog and internet orders that were delivered quickly, as well as those that went slowly.
Create three data sets named work. fast, work. slow, and work. veryslow.
Write a WHERE statement to read only the observations with order_TYpe equal to 2(catalog) or 3(Internet).
Create a variable named ShipDays that is the number of days between when the order was placed and when the order was delivered.
Handle the output as follows:
Output to work. fast when the value of ShipDays is less than 3.
Output to work. slow when the value of ShipDays is 5 to 7.
Output to work. veryslow when the value of ShipDays is greater than 7.
Do not output an observation when the value of ShipDays is 3 or 4.
Drop the variable Employee_ID.
There should be Blank 1 observations in work. fast.
Blank 2 observations in work. slow, and
Blank 3 observations in work. veryslow.
Of the 490 observations in orion. orders, only Blank 4 are read due to the WHERE statement.
Print your results from work. fast. What is the value of ShipDays for observation 11? Blank 5
Print your results from work. slow, what is the value of ShipDays for observation 28?
Print your results from work. veryslow. what is the value of ShipDays for observation 4? Blank 7
 The data set orion.orders contains information on in-store, catalog, and internet

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 Databases Questions!