Counting categorical variables in sas studio

[emma19901]

Hi, I am trying to count categorical variables on the following dataset., I need to count how many players have normal performance on the south team by month., This is an 8,000 observations dataset.

Player	performance	Team                          month
1	High	north                             3
2	normal	south                            7
3	low	north                             5
4	High	north                            9
6	normal	south                           -
7	low	north                           -
8	High	north

[ballardw]

Do you need a data set for further processing (computer use) or a report (people read)?

This example code would provide a count all combinations of performance and team as a report.

proc freq data=have;
  tables performance*team / list missing;
run;

You can subset the data with where statement:

proc freq data=have;
  where performance='normal' and team='south';
  tables performance*team / list missing;
run;

[Ksharp]

proc sql;

select count(distinct player) 

 from have

  group by team,month;

quit;