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?