How to compare any two dates dynamic

[Mauricio_R]

Hi!

I'm trying to compare information in my database choosing any two dates and comparing the information absolute and relative way.

I found a way to choose any two dates and make the absolute comparison but i can´t find how to do the relative comparison (%).
Also, i'm showing the information in two tables; one contains the information for both days and the other only has the comparison, that makes the analysis difficult because the user has to scroll both tables.

Some context:

I'm comparing information that can be added and information that can not be added by sum.

The way to choose both dates is using text input and filtering a table that shows the variables for those days.

For the difference between dates i created a new calculated item that put the information positive for one day and negative for the other, everything else is zero and i use it in a new table aggregating the information.

[PaigeMiller]

Please provide a representative portion of the data, as SAS data steps, following these instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

Please show us the desired end result.