Using a Two-Dimensional Array in SAS

Please complete the following in SAS and provide a copy of your codes

This table illustrates the average manufacturers suggested retail price for shoes, based on product line/product category

The dataset Orion.shoe_sales contains Product_ID, Product_Name and Total_Retail_Price

Create a dataset named COMBINE using a two-dimensional array to combine the table of values with teh product line and product category ID. The product line is the first two digits of the Product_ID variable and the product category ID is the third and fourth digits of the Product_ID variable

final output of the first five obs should resemeble below

Product Category Product Line 2 70.79 173.79 174.40 23 24 29.65 287.8 Product Category Product Line 2 70.79 173.79 174.40 23 24 29.65 287.8