PROC SUMMARY should be able to do this as well.
Something like
proc summary data=have nway; class IDNumber Date; format date monyy.; var value; output out=want mean=meanvalue; run;
if yo like a report you can use the tabulate procedure followed by a transpose:
proc tabulate data=one out=two;
class idnumber month;
table idnumber, month*value*mean;
var value;
run;
proc transpose data=two out=three;
by idnumber;
id month;
var value_Mean;
run;
//Fredrik
Hi.
Thank you for the response this is working perfectly thank you, clearly I was failing as I was using the wrong procedure !!
Last question if I may, if I wanted the same table but summed instead of mean would it be this
proc tabulate data=ZFinal out=Output;
class FDAccountNumber Month;
table FDAccountNumber, Month*Amount;
var Amount;
run;
PROC SUMMARY should be able to do this as well.
Something like
proc summary data=have nway; class IDNumber Date; format date monyy.; var value; output out=want mean=meanvalue; run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.