I have a dataset which contain 3 yeas records, the structure below Company DateTime Amount In VA, i duplicate the datetime column and make it a Month Year only column. I want to build a aging report which show 1 years records from todate to the date 1 year before. Example August/2019 - August/2018. The record before August/2018 will sum up and show in one column. The Month Year column will change when the month is change. Example if it is September, the report will from September/2019 - Sept/2018. Here is the table I wish to show to user. is it possible to do in SAS VA? Please guide me. I'm using SAS VA(8.3.1) on SAS Viya(V03.04) Thanks.
... View more