Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete using PROC SQL statement in SAS please *** s109e02 ***; proc sql; create table work.Products as select distinct * from orion.Product_DIM ; quit; Level
Complete using PROC SQL statement in SAS please
*** s109e02 ***;
proc sql;
create table work.Products as
select distinct *
from orion.Product_DIM
;
quit;
Level 2 2, Creating a Unique Index and Writing a Query Using the Indexed Variable Using the program s109e02 as starter code, create a temporary table work.Products that contains only unique records from orion.Product dim. Create a unique index on your work.Products table based on the column Product ID a. .1 Chapter Review9-3 b. Write a query that joins work.Products and orion.Order fact on Product ID and produces a report of the distinct combinations of Product Name and Supplier Name for records where the year of the Order Date is 2007.Name your report as shown in the sample output Partial PROC SQL Output 2887 Products Purchased Product Name Supplier Name A-tean Smoothsport Bra A-tean Sweat Round Neck, Small Logo Abdomen Shaper Aimait 80% Tungsten 22 Gram A Tean Sports A Team Sports Trimsport B.v Royal Darts Ltd c. Name the indexes, if any, selected by the SQL processor to optimize the query
Step 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