Needing Assistance With Getting A Count of A Particular Variables

pauliet987 — Wed, 30 Nov 2022 14:22:06 GMT

Hi everyone,

I need some assistance with combining variables to create a new variable. What I HAVE:

Zipcode Week_Start. Facility

88888. 4/7/2019. 1

77777. 4/7/2019. 1

88888. 4/7/2019. 1

66666. 4/7/2019. 2

55555. 4/7/2019. 3

77777. 4/14/2019. 1

88888. 4/14/2019. 1

66666. 4/14/2019. 2

55555. 4/14/2019. 3

Some Zipcodes are different (i.e. 77777 and 88888), but they are still associated with the same Facility. I want to be able to get a count of Zipcodes associated with each facility for each week_start. For example, what I WANT:

Week_Start. Facility. Count

04/07/2019. 1. 3

04/07/2019. 2. 1

04/07/2019. 3. 1

04/14/2019. 1 2

04/14/2019. 2. 2

04/14/2019. 3. 1

Thank you for any help you are able to provide!

Re: Needing Assistance With Getting A Count of A Particular Variables

PaigeMiller — Wed, 30 Nov 2022 14:46:19 GMT

Using the answer from your previous thread

You just need to change the TABLE statement in PROC FREQ

tables week_start*facility/list;

topic Needing Assistance With Getting A Count of A Particular Variables in New SAS User

Needing Assistance With Getting A Count of A Particular Variables

Re: Needing Assistance With Getting A Count of A Particular Variables