Sentry Page Protection

Please Wait...

Exercise (7-10)

You are a database developer for Walmart Inc.

​You are in charge of building a program that computes the total price for any online orders.

​Copy and run the code from the yellow box below:

data order1; infile datalines dsd dlm="~"; input item : $50. quantity; datalines; Apples, Gala, bag~1 Bread Crumbs~1 Cold Cuts, ham or chicken~1 Fish 1, frozen (flounder)~1 Fish 2, frozen (tilapia)~2 Ground Turkey, frozen~3 Lemons~1 Mayonnaise~1 Mustard, dijon~1 Pizza, frozen (premium)~2 Potatoes, red~1 Tomato Sauce~1 ; run;

The ORDER1 table contains the items in a customer's shopping cart on Walmart.com. 

​The customer has selected a list of items and the quantities for the order.

Task 1

Write a Proc SQL step to compute the subtotal for each items. The query result should look like this:

The PRICE column should be taken from the WALMART table. The subtotal is calculated as:

SUBTOTAL = PRICE * QUANTITY

Task 2

Based on the query / table from task 1, write a Proc SQL step to create a SAS table that contains the subtotal of the order, $5 shipping charges and the total cost of the order. ​

Name the table as WALMARTPRICE.

The table should look like this:

Next