Solved
New Contributor
Posts: 3

# Count of variable in table

First post and I'm a beginner in SAS.

Looking to count the variables in a table. I have them grouped or sorted. Below is my example:

Table_1

ITEM

red
blue
blue
yellow
yellow
yellow

Expected outcome in new table (Table_2) or appended to Table_1:

ITEM    COUNT

red            1
blue           2
yellow        3

How can I get Table_1 as above or a new Table_2 with the outcome?

Accepted Solutions
Solution
‎03-31-2017 02:33 PM
New Contributor
Posts: 3

## Re: Count of variable in table

Figured it out:

proc freq data = Table_1 order = freq NOPRINT;
tables Item / nocum nopercent out = Table_2 (drop=percent);
run;

All Replies
Super User
Posts: 13,591

## Re: Count of variable in table

Easiest is likely proc freq:

proc freq data=have;

tables item;

run;

to generate a data set add an output data set instruction

proc freq data=have;

tables item/ out=item_count;

run;

the data set Item_count will also have a percent you could remove by adding (drop=percent) after the dataset name.

New Contributor
Posts: 3

## Re: Count of variable in table

I'm sorry, I'm really new to this. How would the suggested code be exactly with Table_1 and Item (my table name and the variable)?

Solution
‎03-31-2017 02:33 PM
New Contributor
Posts: 3

## Re: Count of variable in table

Figured it out:

proc freq data = Table_1 order = freq NOPRINT;
tables Item / nocum nopercent out = Table_2 (drop=percent);
run;