Hello all, Here's my sample data, with date1 representing SAS date value in date9. format: obs date1 amount 1 15Jan2017 25 2 17Jan2017 74 3 28Jan2017 10 4 01Feb2017 18 5 16Feb2017 37 6 20Feb2017 50 7 27Feb2017 44 ....... and so on, with each coming month new records will be added. I need to calculate sum of amount for month to date time interval. For example, today being 26th day of a month: if date1 is between the first day of a particular month and 26th, then do the sum For Jan, if date1 between 01Jan2017 and 26Jan2017 then new_col=sum(amount), etc. What would look like this at the end: Month new_col Jan2017 99 Feb2017 105 ...... I'm looking for universal way to code this, in some sort of loop or macro. Any suggestions would be most welcome. Thanks in advance.
... View more