topic Assistance with Proc Summary in SAS Procedures

Assistance with Proc Summary

Stretlow — Thu, 28 Sep 2017 10:26:43 GMT

Hi there. Im struggling a little bit with a proc summary. I have a large data set that holds 3 variables: an IDNumber(Char) a date (date format) and a value (200.00) the whole period covers March to August I'm trying to summarise it so it outputs an average value per IDNumber for each month. I'd like the table in the following way:- Ive attached a sample table of how im trying to make the sample look

Re: Assistance with Proc Summary

FredrikE — Thu, 28 Sep 2017 10:54:07 GMT

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

Re: Assistance with Proc Summary

Stretlow — Thu, 28 Sep 2017 12:55:22 GMT

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;

Re: Assistance with Proc Summary

PaigeMiller — Thu, 28 Sep 2017 14:52:08 GMT

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;