Count of variable in table

[AdamR]

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]

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]

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 · Accepted solution]

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!