Answered step by step
Verified Expert Solution
Link Copied!

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;

image text in transcribed

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

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

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions

Question

Demonstrate three aspects of assessing group performance?

Answered: 1 week ago