Hi all, So as I'm working through this it seems like the key is that in order to treat the elements of a lookup table like variables, I need to put them into an array. Is that correct? So, for example if I have a sale, 1 item for $4, or 4 items for $12, if I buy 5 items then I would need to take the price for 4 items, subtract the 4 items from the total, and then add the price for the 1 item, subtract that 1 item from the total, and now that I'm at zero items, I leave the loop. Sorry, I've never worked with arrays in SAS before. So I'm assuming that to use an array like a lookup, its always going to look for the i'th element. So instead of thinking "lookup the element that corresponds with sale_scenario_4," I have to think, "lookup the 4th element in the array and make sure that you have the value for sale-scenario_4 there." Is that right?
... View more