topic Re: Simple Tally Using Proc Tabulate in SAS Procedures

Simple Tally Using Proc Tabulate

NKormanik — Fri, 14 Jul 2017 06:08:08 GMT

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 — Fri, 14 Jul 2017 11:37:36 GMT

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 — Fri, 14 Jul 2017 15:01:01 GMT

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;