Hi,
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
Input table:
ID Repdate Amount
1 31DEC2020 2000
1 31DEC2021 3000
1 30SEP2020 1500
1 30SEP2021 3000
Output table:
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?
Bart
Can you post the input table as working data step code?
You want the output as html/pdf/excel, not as dataset, right?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: