topic Re: Showing frequencies by week instead of day in SAS Programming

Showing frequencies by week instead of day

claremc — Sat, 05 Dec 2020 20:34:29 GMT

Hello,

I am running a bunch of frequencies on outcomes by date, and I need the frequencies to appear by date in weeks instead of daily. I need the outcomes to appear with the week date labeled -- for example, "03/15/2020, Outcome X, Outcome Y. "03/22/2020, Outcome, X, Outcome Y', etc. I tried the "week" command (see below), but that just numbers the weeks and doesn't put them into an easy to read format.

data covidzip7; 
set covidzip6; 
rdate_wk = week(rdate, 'v'); 
format rdate_wk mmddyy10.; 
run; 

proc freq data = covidzip7; 
tables rdate_wk*race_new*agecat; 
run;

Can anyone help? Thanks!

Re: Showing frequencies by week instead of day

Kurt_Bremser — Sat, 05 Dec 2020 20:43:06 GMT

Apply one of the YYWEEK formats to your rdate.

Re: Showing frequencies by week instead of day

PaigeMiller — Sat, 05 Dec 2020 21:03:58 GMT

I assume you want the first day of the week to be used (3/15/2020). This code will turn every date into the first day of the week, using the INTNX function.

data covidzip7; 
set covidzip6; 
rdate_wk = intnx('week',rdate,0,'b');
format rdate_wk mmddyy10.; 
run; 
proc freq data = covidzip7; 
tables rdate_wk*race_new*agecat; 
run;

Re: Showing frequencies by week instead of day

claremc — Sat, 05 Dec 2020 21:36:40 GMT

This worked - thank you so much!

Re: Showing frequencies by week instead of day

MarySasbegginer — Sat, 08 Oct 2022 00:53:01 GMT

looking for help with my sas homework
really new to sas and coding
really need help
anyone?

Re: Showing frequencies by week instead of day

Kurt_Bremser — Sat, 08 Oct 2022 03:43:27 GMT

Start a new thread of your own.

Describe your issue.

Post example data in usable form (data step with datalines, you can find thousands ofe xamples here on the communities).

Show expected results.

Most importantly, show what you have already tried so far. We are glad to assist when people run into problems, but we won't do others work for free.

If you need someone to do your work for you, hire a consultant.

tutor for homework

MarySasbegginer — Sat, 08 Oct 2022 17:30:14 GMT

Hi Kurt,

I don't want anyone to do my homework for me, why you assumed that?

But my problem is that we do 2 , 3 chapters a week and no matter how much i tried i always behind.

So in order to do my homework i need to understand how to do it which i don't yet hence asking for help.

Anyway thank you for you reply.

Re: tutor for homework

PaigeMiller — Sat, 08 Oct 2022 20:52:54 GMT

@MarySasbegginer

Follow the advice given by @Kurt_Bremser and people will help you. He said:

Start a new thread of your own.

Describe your issue.

Post example data in usable form (data step with datalines, you can find thousands ofe xamples here on the communities).

Show expected results.

Most importantly, show what you have already tried so far.