Well, in this case Suppliers usually use the same stack height across their products. There are actually a few more variables I would use to make the prediction. In this case it is for TV size. So if a TV has a sku of 123 and supplier of LG and is 50-60 inches tall, I'd look to see what LG usually stacks for TVs in that size range and then input that value. That's how i've been doing it manually. I'm trying to figure out how to do it in SAS so I can do it on a larger scale. So in my example data I'd say the missing Sony value should be 5 and the missing LG value should be 3.75 and Toshiba would be 5. Does that make sense?
... View more