BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AdamR
Fluorite | Level 6

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
AdamR
Fluorite | Level 6

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

3 REPLIES 3
ballardw
Super User

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
Fluorite | Level 6

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
Fluorite | Level 6

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!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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