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)
I think it is possible using the rank function.
First create a numeric variable containing the month (201901, 201902....)
Then use the rank function and list the top 13 months by the new numeric variable.
The rest of the months will automatically sum in the other category if you have the check box selected.
I try to create a numeric variable containing month year. When I use rank function, it need me select Top Count or Top percent and then By. In the "By" drop down list, I select amount but the result is not in order for the month in current year. It show the top amount in order. How I can fix this?
Registration is open! SAS is returning 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. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.