I have looked at a number of conditional formatting questions, but none seem to quite get what I'm after. I'm frustrated, because I believe I went to a conference where someone talked about using proc format but being able to apply it conditionally, and I think I've successfully done it in the past but can't find a program using that method. I would also be willing to use proc report, but it's newish to me!
What I'm trying to do is apply a format to var2 based on the value of var1. So if var1 is 'food' then var2 should be 'broccoli'. If var1 is 'auto' then var2 should be 'sedan'. Obvious oversimplification, but that's what I'm trying to do.
... View more