https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-compare-any-two-dates-dynamic/m-p/561993#M12554 <P>Please provide a representative portion of the data, as SAS data steps, following these instructions:&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A></P> <P>&nbsp;</P> <P>Please show us the desired end result.</P> Tue, 28 May 2019 15:03:13 GMT PaigeMiller 2019-05-28T15:03:13Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-compare-any-two-dates-dynamic/m-p/561990#M12553 <P>Hi!</P><P><BR />I'm trying to compare information in my database choosing any two dates and comparing the information absolute and relative way.</P><P>&nbsp;</P><P>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 (%).<BR />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.</P><P>&nbsp;</P><P>Some context:</P><P>I'm comparing information that can be added and information that can not be added by sum.</P><P>The way to choose both dates is using text input and filtering a table that shows the variables for those days.</P><P>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.</P> Tue, 28 May 2019 15:00:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-compare-any-two-dates-dynamic/m-p/561990#M12553 Mauricio_R 2019-05-28T15:00:03Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-compare-any-two-dates-dynamic/m-p/561993#M12554 <P>Please provide a representative portion of the data, as SAS data steps, following these instructions:&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A></P> <P>&nbsp;</P> <P>Please show us the desired end result.</P> Tue, 28 May 2019 15:03:13 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-compare-any-two-dates-dynamic/m-p/561993#M12554 PaigeMiller 2019-05-28T15:03:13Z