I am needing to create an advanced filter while the information map, the filter would be a prompt for an initial period least 365 days, you have any suggestions?
Can you provide more detail about your goal?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Hi,
The solution little bit depends how the date data item is used in your information map.
What I tried and maybe helps you is this(I used dummy data for testing).
data library.test_data;
input mon date9. value;
datalines;
01Feb2014 15
01Jan2014 10
01Dec2013 28
01Nov2013 30
01Oct2013 15
01Sep2013 30
01Aug2013 20
01Jul2013 20
01Jun2013 20
01May2013 20
01Apr2013 20
01Mar2013 20
;
Then in the information map studio I defined mon data item as "Date" type and used format EURDFMY and called it DataItem1.
Next I created filter that looks like this:
And when I test this filter, I get this selection:
and results are here:
Kind Regards,
Rain
Rain,
The problem is that the second date (to) not being in accordance with the first choice, it is always based on the current date minus the number of months in crate side.
Example:
From Date: Dez 14
To Date: N Months ago (Feb 14, Jan 14, Dez 14, Nov 14, Oct 14 , Sep 14 )
right would
From Date: Dez 14
To Date: N Months ago (Dez 14, Nov 14, Oct 14 , Sep 14, Ago 14 )
Tks
wrosario wrote:
Rain,
The problem is that the second date (to) not being in accordance with the first choice, it is always based on the current date minus the number of months in crate side.
Example:
From Date: Dez 14
To Date: N Months ago (Feb 14, Jan 14, Dez 14, Nov 14, Oct 14 , Sep 14 )
right would
From Date: Dez 14
To Date: N Months ago (Dez 14, Nov 14, Oct 14 , Sep 14, Ago 14 )
Tks
Hi again,
Your requirement is something that I am not sure can be achieved- dynamic calculation. Or maybe someone else with more knowledge can help you out.
Rain
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.