topic Re: proc tabulate, formats in New SAS User

proc tabulate, formats

hein68 — Thu, 14 Nov 2019 15:55:42 GMT

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;

Re: proc tabulate, formats

mkeintz — Thu, 14 Nov 2019 16:14:03 GMT

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).

Re: proc tabulate, formats

hein68 — Thu, 14 Nov 2019 16:25:06 GMT

That worked, thanks very much!