I have a dataset with multiple variables. I want to show a certain value like 'less than 100k' for values less than 100k on a frequency table. I am trying to use the following code but it is not working. Could it be because they are numerical variables and I want to make them show character values? TIA proc format;
value $Inv inventory<100000 ='Under $100k'
100000<inventory<150000 ='$100k-$150k' inventory>150000 = 'More than $150k';
value $Sale sales<100000 ='Under $100k'
100000<sales<150000 ='$100k-$150k' sales>150000 = 'More than $150k';
... View more