Please assist with full code using proc sql; procedure in sas Creating and Using
ID: 3881003 • Letter: P
Question
Please assist with full code using proc sql; procedure in sas
Creating and Using a View to Provide Consolidated Information a. Create a view named orion.T Shirts containing the following columns: Product ID Supplier Name (formatted as $20.) Product Name Price (Label it Retail Price.) Use data from the following tables: (Columns of interest are in parentheses.) ·orion. Product Dim (Product ID, Product Name, Supplier Name) orion.Price_list (Product_ID, Unit_Sales_Price) Select only those records where Product Name includes the word T-Shirt. b. Write a query to display the data from your new orion.T Shirts view. Sort the report by Supplier Name and Product ID. Supply a useful title. Partial PROC SQL Output Available T-Shirts Product ID Supplier Name Product Name Aetail Price S19.60 S31.70 S33.60 Kid Children's T-Shirt T-Shirt T-Shirt, Short-Sleeved, Big Logo Men's T-Shirt Small Logo Toncot Beefy-T Emb T-Snirt Toncot Beefy-T Emb T-Shirt 210201000050 3Top Sports 240500200016 3Top Sports 220101300001 A Tean Sports 220101300012 A Team Sports 220101300017 A Tean Sports S19.40 S16.60 220101300017 A Tean Sports S16.60 Write a query using your new orion.T_Shirts view to display Product ID Product Name, and Price for all T-shirts priced less than $20.00. Sort the report by price. Supply a useful title. c. PROC SQL Output T-Shirts under S20 Retail Price Product ID Product Nane 220101300017 Toncot Beefy-T Enb T-Shirt 220101300012 Nen's T-Shirt Smal1 Logo 210201000050 kid Chidren s T-Shirt 16.60 19.40 $19.60Explanation / Answer
A) create view T_shirts as select a.product_id,a.supplier_name,product_name,sales as retail_price
from orion.product_dim a inner join orion.price_list b on where a.product_id=b.product_id
b)select product_id,supplier_name,product_name,retail_price from T_shirts order by supplier_name,product_id
c)select product_id,product_name,retail_price from T_shirts where retail_price<20 order by retail_price
a)create table dbo.rewards(purchased int,year date,leval nvarchar(10),award nvarchar(50))
b)insert into rewards(purchased,year,leval,award)values(200,'2006','sliver','25% discount over on one item over $25')
,(300,'2006','gold','15% discount over on one item over $50'),(500,'2006','platinum','10% discount on all 2007 purchases '),
(225,'2007','sliver','25% discount over on one item over $80'),(350,'2007','gold','15% discount on order over $1000'),
(600,'2007','platinum','10% discount on all 2008 purchases')