Best way to sum counts of a variable by group?

SAS93 — Fri, 21 May 2021 13:11:38 GMT

I have two variables from a dataset: county and facilityname.

I want to essentially see the county "spread" of each facility, so I can see which facilities are most frequently serviced by each county and vice versa.

While I could do a crosstab using proc freq of these two variables, I want to get a more "summarized" output because there are 100-150 different facility names and about 100 counties.

I tried using the FIRST.facilityname by county approach, but that severely limited my overall output/number of observations.

Re: Best way to sum counts of a variable by group?

ballardw — Fri, 21 May 2021 14:31:06 GMT

@SAS93 wrote:

I have two variables from a dataset: county and facilityname.

I want to essentially see the county "spread" of each facility, so I can see which facilities are most frequently serviced by each county and vice versa.

While I could do a crosstab using proc freq of these two variables, I want to get a more "summarized" output because there are 100-150 different facility names and about 100 counties.

I tried using the FIRST.facilityname by county approach, but that severely limited my overall output/number of observations.

I'm afraid that you may need to provide some example of what you mean by "more "summarized" output.

It also sounds like you may not be sure just how many facility names are involved.

Something like:

Proc summary data=have nway;
   class facility county;
   output out=summary (drop=_type_);
run;

Will generate a data set with just the counts of facilty county combinations in your data set. The variable _freq_ will have the count.

You can change the order of the variables on the Class statement to get the output in different order or sort the data.

topic Re: Best way to sum counts of a variable by group? in SAS Programming

Best way to sum counts of a variable by group?

Re: Best way to sum counts of a variable by group?