topic Proc format in SAS Programming

Proc format

SASPhile — Tue, 05 May 2015 17:57:43 GMT

I'm looking to format fico score difference between the months and categorize. I'm using the proc format to do it. but the issue I'm facing is the negative or decrease in fico between current and previous months ,the proc format doesnt seem to take my negative scores properly. the first category -10 - <0 is not taking properly. I woiuld like to define other negative scores as well.

proc format;

value diff

-10 - <0 = '-10'

0 - <15 = '0-14'

15 - <30 = '15-29'

30 - <50 = '30-49'

50 - <100 = '50-99'

100 - High = '100+';

run;

data t;
input score;
cards;
100
-20
-30
-10
10
20
0
;
run;

data y;
set t;
format score diff.;
run;

Re: Proc format

SASKiwi — Tue, 05 May 2015 19:36:37 GMT

What do you expect to happen with the -10 - < 0 range? The only test value matching this range is -10 and when I run your code it displays as -10 which is exactly what you specified: -10 - <0 = '-10'

Re: Proc format

ballardw — Tue, 05 May 2015 22:41:09 GMT

Default behavior for custom formats: If you have a data value that is not in the range given it will display with a BEST value.

So -20 and -30, since there is no specific instruction for them will display as -20 and -30 exactly as expected.

If you want ALL negative values to show in the same range then use

LOW - < 0