proc tabulate, formats

[hein68]

Hello.  I'm making a bunch of tables in proc tabulate.  I need to use a format that formats all values less than or equal to 10 with <=10 (I'm using the numb. format for this).  That works fine.  However, I also want values over 999 to have the comma7 format (so I need both formats).  This is the code that I am using (see below).  How can I get both formats applied?

proc tabulate data=top25adults f=comma7.;
   class diag1ccs / order=freq;
   class female aweekend dispuniform_4cat;
   table diag1ccs=' ',
         (all='Adults' female=' ' aweekend=' ' dispuniform_4cat=' ') * n=' '*f=numb.
         /box='Diagnosis' 
   ;

This is what the numb. format looks like:

value numb 
0-10 = "<=10"
other = [best7.]
;

Thanks!
  
   

run;
title;

[mkeintz · Accepted solution]

You can apply the COMMA. format to a sub-range just the same as you have already applied the BEST format:

proc format;
  value numb 
    0-10 = "<=10"
    999-HIGH=[comma8.0]
    other = [best7.];
run;

Note you don't have to list the subranges in any particular order.  So this one does the low positive number, then the high ones, and then all the others (including numbers in the middle range).

[hein68]

That worked, thanks very much!