Help using Base SAS procedures

Simple Tally Using Proc Tabulate

Accepted Solution Solved
Reply
Regular Contributor
Posts: 212
Accepted Solution

Simple Tally Using Proc Tabulate

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

 

 


Accepted Solutions
Solution
‎07-14-2017 06:49 PM
Super User
Posts: 10,500

Re: Simple Tally Using Proc Tabulate

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;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,381

Re: Simple Tally Using Proc Tabulate

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.

Solution
‎07-14-2017 06:49 PM
Super User
Posts: 10,500

Re: Simple Tally Using Proc Tabulate

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;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 131 views
  • 0 likes
  • 3 in conversation