I use PC SAS and I've been challenged to create a Month over Month trending for the data sample example below. I'd like to show the change in the total number of accounts (account_ID) per month - rolling forward month over month. (The data table I'll be using has 13 months of data.) Thanks in advance!
Data_Have:
Account_ID Month
123 01/01/2020
456 01/01/2020
055 02/01/2020
077 02/01/2020
951 02/01/2020
159 02/01/2020
357 03/01/2020
038 04/01/2020
999 04/01/2020
Data_Need:
Month Total_Accounts Percent_Change
01/01/2020 2 .
02/01/2020 4 50
03/01/2020 1 -75
04/01/2020 2 50