I need to compare this quarter vs previous quarter with the following output
From input table, i need to compare 2 quarters current and previous
ID Repdate Amount
1 31DEC2020 2000
1 31DEC2021 3000
1 30SEP2020 1500
1 30SEP2021 3000
ID Repdate Amount Previousqtr Amount
1 31DEC2020 2000 30SEP2020 1500
1 31DEC2021 3000 30SEP2021 3000
Thanks in advance
What did you try up to now?
I didn't asked what do you want (I can tell that from the first post). I asked what did you try so far? What code have you wrote?
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.