Hello Everyone, I am trying to use a two-dimensional array for a particular homework problem. The data set orion.msp contains the average manufacturer’s suggested retail price for shoes, based on the product line and the product category. The product group ID is the last two digits of ProdCatID. Listing of orion.msp orion.MSP Prod_ Prod Avg_Suggested_ Obs Line CatID Retail_Price 1 21 2101 . 2 21 2102 70.79 3 22 2201 173.79 4 22 2202 174.40 5 23 2301 . 6 23 2302 . 7 24 2401 29.63 8 24 2402 287.80 The data set orion.shoesales contains the ProductID, the ProductName, and the TotalRetailPrice for all of the shoes sold by Orion Star. Partial Listing of orion.shoesales Total_Retail_ Product_ID Product_Name Price 220200200024 Pro Fit Gel Gt 2030 Women's Running Shoes $178.50 220200100092 Big Guy Men's Air Terra Sebec Shoes $83.00 240200100043 Bretagne Performance Tg Men's Golf Shoes L. $282.40 220100700024 Armadillo Road Dmx Women's Running Shoes $99.70 220200300157 Hardcore Men's Street Shoes Large $220.20 240200100051 Bretagne Stabilites 2000 Goretex Shoes $420.90 220200100035 Big Guy Men's Air Deschutz Viii Shoes $125.20 220200100090 Big Guy Men's Air Terra Reach Shoes $177.20 220200200018 Lulu Men's Street Shoes $132.80 240200100052 Bretagne Stabilities Tg Men's Golf Shoes $99.70 I tried to do the following : data Q9;
if _n_=1 then
do until(lr);
set orion.msp end=lr;
PK = input(substr(ProductID,3,2),2.);
array D{21:24, 01:02};
D(ProdLine, PK) = AvgSuggestedRetailPrice;
end; retain D;
set orion.shoesales;
PL= input(substr(ProductID,1,2),2.);
PC= input(substr(ProductID,3,2),2.);
MSP= D{PL, PC};
run; proc sql; title 'combine Data Set'; select MSP 'Manufacturer Suggested Price' format=COMMA10.2, ProductID, ProductName, TotalRetailPrice from work.Q9; run; However, I keep on getting the error message that the array subscript is out of range. I don't know what to do.. Any help would be appreciated! Eventually I would need to get a table that would look like this: Suggested Price ProductID ProductName Price $174.40 220200200024 Pro Fit Gel Gt 2030 Women's Running Shoes $178.50 $174.40 220200100092 Big Guy Men's Air Terra Sebec Shoes $83.00 $287.80 240200100043 Bretagne Performance Tg Men's Golf Shoes L. $282.40 $173.79 220100700024 Armadillo Road Dmx Women's Running Shoes $99.70 $174.40 220200300157 Hardcore Men's Street Shoes Large $220.20
... View more
