Convert multiple days (~3 months) into weekday averages

kkashy — Thu, 29 Sep 2022 23:25:27 GMT

Hi All,

New to SAS here, so please bare with me if this is a simple fix.

Below is a screenshot of some of the data I am utilising.

Using the query builder, I converted the t1.date into weekays, ie. Monday, Tuesday using format DOWNAME.

I am now trying to get an overall weekday average of the data. This should be in the form (as an example)

date Aluminium

Monday 16.6

Tuesday 7.8

etc until Sunday for all data points.

This data is tangible for the last 3 months, where I currently have the report running for today to 3 months ago.

Any help to get this output would be greatly appreciated.

Re: Convert multiple days (~3 months) into weekday averages

Shmuel — Fri, 30 Sep 2022 04:32:52 GMT

Try next code:

proc means data=have noprint;
   class date;
   format date downame;
   var Aluminium;
   output out=want mean=Average ;
run;