@jbatch wrote:
Thanks Tom - that solved my issue. I still feel like I remember that there is a way, in the proc format itself, to apply the conditions based on the value of the variable being formatted. But, it was a long time ago!
That is only possible if the range of values do not overlap. So if 1-10 is used for food and 100-200 is use for autos you could make a format like this:
proc format;
value combo
1-10=[food.]
100-200=[auto.]
;
run;
... View more