Using a One-Dimensional Array as a Lookup Table IN SAS

Please provide a copy of your ideal codes (or at least a framework to complete this)

Use arrays to create a data set named Trans that has 24 observations from a data set named Orion.shoe_stats

Shoe_stats table looks like

based on this table, the final output should look similar to

shoe stats Product23 Product24 Stat Product21 Product22 18 277 1 Frequency 2 Mfg Suggested_RetailPrice Mean 70.787878788 174.29241877 3 Mfg_Suggested_Retail Price_Min 4 Mfg Suggested_Retail Price_Max 5 Mfg_Suggested_Retail Price_Median 6 Mfg Suggested Retail Price_StdDev 21.730882067 71.702568882 173.05555556 17 130 68 13 385 164 398 190.5 141.38868921