Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.60Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started