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
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!