Need Help Totaling Multiple Observations From the Same Column Into One New Variable.

pauliet987 — Tue, 29 Nov 2022 20:27:16 GMT

Hello,

I am trying something I have never done before, and I can't get it right. Essentially, I have a bunch of Zipcodes associated with a particular Week_Start date. For example,

What I have

Zipcode Week_Start

04662. 02/27/2018

14738. 02/27/2018

04662. 02/27/2018

14738. 03/06/2018

04662. 03/06/2018

04662. 03/13/2018

14738. 03/20/2018

What I want to do is sum the total observations of Zipcodes for a particular Week_Start. For example,

What I want:

Total_ZipCodes Week_Start

3 02/27/2018

2. 03/06/2018

1 03/13/2018

1 03/20/2018

Thank you so much for any help you are able to give!

Re: Need Help Totaling Multiple Observations From the Same Column Into One New Variable.

PaigeMiller — Tue, 29 Nov 2022 20:33:18 GMT

proc freq data=have;
    tables week_start;
run;

If you want the results in a SAS data set, then this should do it:

proc freq data=have;
    tables week_start/out=counts;
run;

topic Need Help Totaling Multiple Observations From the Same Column Into One New Variable. in New SAS User

Need Help Totaling Multiple Observations From the Same Column Into One New Variable.

Re: Need Help Totaling Multiple Observations From the Same Column Into One New Variable.