topic How to aggregate daily data? in All Things Community

How to aggregate daily data?

bd_user_10 — Sat, 25 Aug 2018 15:21:53 GMT

HI SAS Community,

I have the following data:

Date SEDOL Volume

2013-03-15 5556586 7, 000

2013-03-15 5556586 8, 000

2013-03-15 5556586 5, 000

2013-03-15 5556586 2, 000

2014-03-15 5556587 9, 000

2014-03-15 5556587 6, 000

2014-03-15 5556587 5, 000

I need the data like this

Date SEDOL Volume

2013-03-15 5556586 22, 000

2014-03-15 5556587 25, 000

Thanks in advance for your help. Cheers!

PaigeMiller — Sun, 26 Aug 2018 00:35:42 GMT

Try this:

proc summary data = have;
    class date sedol;
    var volume;
    output out=want sum=;
run;

bd_user_10 — Sun, 26 Aug 2018 02:20:30 GMT

Thanks. That works perfectly!