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;
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'
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.