Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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.60

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 12c SQL

Authors: Joan Casteel

3rd edition

1305251032, 978-1305251038

Students also viewed these Databases questions

Question

What is meant by a green or sustainable strategy?

Answered: 1 week ago