I have data that looks like the following as a data set in SAS (goes on for multiple years):
Date | Dollar Amount |
07/14/2020 | 50 |
07/14/2020 | 20 |
07/14/2020 | 10 |
07/15/2020 | 30 |
07/15/2020 | 5 |
07/15/2020 | 67 |
I want to sum the dollar amount for each date to return one summed amount for each date in a new table that looks like the following:
Date | Dollar Amount |
07/14/2020 | 80 |
07/15/2020 | 102 |
How do I create this new table?