topic Re: Count of variable in table in SAS Programming

Count of variable in table

AdamR — Fri, 31 Mar 2017 17:24:40 GMT

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?

Thanks - Adam

ballardw — Fri, 31 Mar 2017 17:29:20 GMT

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.

AdamR — Fri, 31 Mar 2017 17:52:34 GMT

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)?

Thanks - Adam

AdamR — Fri, 31 Mar 2017 18:32:53 GMT

Figured it out:

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

Thanks for your help ballardw!