Needing Assistance With Getting A Count of A Particular Variables

[pauliet987]

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

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! 

[PaigeMiller · Accepted solution]

Using the answer from your previous thread

You just need to change the TABLE statement in PROC FREQ

tables week_start*facility/list;