Counting frequency in SAS

I have a dataset that has and ID number, Group_1 and Group_2.  The file looks like this:
ID              Group_1        Group_2
1                  44                   44                                
3                  44                   44  
4                  55                   44
5                  22                   22

What is the best way to get the total number of individuals in each group?   In this case ID 4 would be in both Group 55 and Group 44.
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
Aloysius LowCommented:
not sure if this is what you are looking for, assuming the dataset containing the data is GROUP:

PROC SORT
      DATA=WORK.GROUP(KEEP=group1 group2 id)
      OUT=WORK.GROUP_SORTED;
      BY id;
RUN;

PROC TRANSPOSE DATA=WORK.GROUP_SORTED
      OUT=WORK.GROUP_TRANSPOSED;
      BY id;
      VAR group1 group2;
RUN;

PROC SQL;
      create table WORK.FREQUENCY as
            select COL1, COUNT(*) as FREQ
            from WORK.GROUP_TRANSPOSED
            group by COL1;
quit;

result:
Group 22: 2
Group 44: 5
Group 55: 1
0
 
moriniaAdvanced Analytics AnalystAuthor Commented:
It worked great!!! Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.