Orion.product table 2. Using Formats to Limit the width of Columns in the output

Question

Orion.product table 2. Using Formats to Limit the width of Columns in the output Write a query that retrieves the Supplier Name Product Group, and Product Name columns from the table orion,product dim. a. Add this title to the report: Australian Clothing Products. b. clude only rows where the following are true: Product category Clothes and Supplier country "AU" (Australia) c. To enable the report to be printed in portrait orientation, use formats to limit the width of the Supplier Name column to 18 characters, Group to 12, and Product me to 30. d. Label the columns Supplier, Group, and Product, respectively. e. Order the report by Product Name. PROC SQL output Australian Clothing Products Group Product Supplier Street Wear Tyfoon Flex Shorts Typhoon clothing Street Wear Ty foon Ketch T-Shirt Typhoon clothing Street Wear Tyfoon Oliver Sweatshirt Typhoon clothing

Explanation / Answer

proc sql;

create table supplier_data as

select suppplier_name, product_group,product_name

from orion.product_dim;

quit;

(a)

proc sql;

select * from supplier_data

where product_category='Clothers' and supplier_country = 'AU'

from orion.product_dim;

quit;

c)(d)(e)

data temp1(drop = supplier_name product_name group rename=(s_n = supplier_name p_n =product_name g= group));

set orion.product.dim;

format s_n $18.;

format g $12.;

format p_n $30.;

run;

proc sort data = temp1 out= temp2;

by product_name;

run;

proc sql;

select supplier_name as Supplier, group as group, product_name as Product

from temp2 ;

quit;

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.