Convert multiple days (~3 months) into weekday averages

[kkashy]

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. 

[Shmuel]

Try next code:

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