DATA Step, Macro, Functions and more

Count of variable in table

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

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?

Thanks - Adam

 

 


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;

 

Thanks for your help ballardw!

View solution in original post


All Replies
Super User
Posts: 10,490

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

Thanks - Adam

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;

 

Thanks for your help ballardw!

☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 134 views
  • 1 like
  • 2 in conversation