Simple Tally Using Proc Tabulate

[NKormanik]

The following code produces a horizontal tally -- each unique observation becomes a column heading, with number of occurrences below:

proc tabulate data=sas_1.top_20;
class i2;
table i2;
run;

Does anyone know of a way to use Proc Tabulate and get a vertical list, with tally number to the right of each categorical observation?

Cats   17

Dogs   12

Birds    9

etc.

Thanks,

Nicholas Kormanik

[Shmuel]

If all you have are the two variables, why not use proc print ?

Proc tabulate is usefull for summarizing data and reporting it as a table.

[ballardw · Accepted solution]

Try

proc tabulate data=sas_1.top_20;
class i2;
table i2 ,
         n;
run;

if you don't want any column heading

proc tabulate data=sas_1.top_20;
class i2;
table i2=' ' ,

         n=' ';
run;