9. Using a two-dimensional array

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

The data set orion.msp contains the average manufacturers suggested retail price for shoes based upon the product line and product category. the product group ID is the last two digits of Prod_Cat_ID

The data set orion.shoe_sales contains product_ID, Product_Name and Total_Retail_Price for all shoes sold

using these datasets, generate a code that will create a dataset named Combine1 using a two-dimensional array to combine the table of values from orion.msp with orion.shoe_sales. Include a new variable named Manufacturer_Suggested_Price which is based on the values of product line and product category. The product line is the first two digits of Product_ID. The product category ID is the third and fourth digits of the product_ID variable. Keep only Product_ID, Product_Name, Total_Retail_Price and manufacturer_suggested_price.

A proc print output of the first 5 obs should resemble the sample below

msp Prod Line Prod _Cat ID Avg Suggested_Retail_Price 21 21 2101 2102 2201 2202 2301 2302 2401 2402 2 70.787878788 173.79166667 174.39737991 4 23 23 24 24 6 29.625 287.8 msp Prod Line Prod _Cat ID Avg Suggested_Retail_Price 21 21 2101 2102 2201 2202 2301 2302 2401 2402 2 70.787878788 173.79166667 174.39737991 4 23 23 24 24 6 29.625 287.8