Test Content

1. Question 1Question 1

1. 10 Points

1. Question 1

The data setorion.web_productscontains an observation for every product available

for sale on Orion Star's wholesale Web site.

Partial Listing oforion.web_products

Product_IDPriceProduct_Name

120400304333114.36Smasher Super Rq Ti 350 Tennis Racket

12040030528853.26Knife

120400305846107.74Big Guy Men's Air Deschutz Viii Shoes

12040030876640.96Big Guy Men's Packable Hiking Shorts

12040030884912.23Wood Box for 6 Balls

The data setorion.web_orderscontains a list of orders made in a single day from the

Web site. Each observation contains the product ID, the quantity ordered, and the customer's

name.

Partial Listing oforion.web_orders

Product_IDQuantityCustomer

12040030528816Carglar Aydemir

12040030528819Sanelisiwe Collier

12040030584613Candy Kinsey

12040030584613Cynthia Martinez

The two data sets are sorted byProduct_ID.

In a data step, createthreedata sets:

A data set namedrevenuecontains the product code (Product_ID), the price (Price), the quantity sold (Quantity), the product name (Product_Name), the customer name (Customer), and the revenue generated from each sale (Revenue).Revenueis a new variable that is equal toPrice*Quantity.

A data set namednotsoldcontains the product code (Product_ID), price (Price),

and product name (Product_Name) for each product that was not sold.

A data set namedinvalidcodecontains the product code (Product_ID), quantity (Quantity), and customer name (Customer) for each observation in theweb_orders

data set that does not have a corresponding product code in theweb_productsdata set.

Submit your data step in SAS, examine the SAS log and result tables.

There were Blank 1 observations read from the data set orion.web_products.

There were Blank 2 observations read from the data set orion.web_orders.

The data set revenue has Blank 3 obseervations and Blank 4 variables.

The data set notsold has Blank 5 obseervations and Blank 6 variables.

The data set invalidcode has Blank 7 obseervations and Blank 8 variables.

what do i put in the blanks?