## Simple Tally Using Proc Tabulate

Solved
Regular Contributor
Posts: 238

# 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: 13,583

## 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;
```

All Replies
Posts: 1,837

## 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: 13,583

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