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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.