Hi @SKG,
I think I have a solution, but you will need to make some changes in your source table. Before we start, I'd like to make a correction: 08 Aug 2016 - 364 is 10 Aug 2015 (not 07 Aug 2015 as provided in your example). Having said that. I'm using the corrected date in my example below.
First, you need to restructure your input table as below:
Then you create an auxiliary calculated column that adds 364 to the Date column (you could have that column added to your source table if you want):
Next, I assume you have a way to select a date (e.g. 08-Aug-2016) for filtering. You need to assign that date to a parameter. I've already shared with you in another thread an article that should help solve this step (please see ), and derive a date calcualted column (e.g Selected_Date) from that parameter. This is also explained in the article. This is what you should have now:
The last step is to derive current and previous revenues. It would be something like this:
Curr_Rev:
if 'Selected_Date'n = 'Date'n
return Rev
else .
Prev_Rev:
if 'Selected_Date'n = 'Date+364'n
return Rev
else .
This would give you the table below:
Now you should have all elements necessary to display and aggregated table that looks like what you want:
Best,
Renato
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.
-
1731 views
-
0 likes
-
-
