topic Display different values for a dataset based on range of values in New SAS User

Display different values for a dataset based on range of values

turbanator — Fri, 07 Jul 2023 00:40:36 GMT

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';

Re: Display different values for a dataset based on range of values

PaigeMiller — Fri, 07 Jul 2023 10:20:37 GMT

proc format;
    value dollarf inv 0<100000 ='Under $100k'
         100000-<150000 ='$100k-$150k' 150000-high = 'More than $150k';
    value sales 0-100000 ='Under $100k'
         100000-<150000 ='$100k-$150k' 150000-high = 'More than $150k';
run;

In PROC FORMAT, you specify ranges differently than you would in an IF statement. You specify the low value of the range, a dash and then the high value of the range.

Could it be because they are numerical variables and I want to make them show character values?

Not a problem, that's one of the huge benefits of PROC FORMAT is that numerical value ranges can be represented as a text string.

Re: Display different values for a dataset based on range of values

ballardw — Mon, 10 Jul 2023 20:11:41 GMT

One of the other strengths of the Format for display is when multiple values are to be displayed with the exact same range descriptions only ONE format is needed.