01-18-2012 09:52 AM
Not sure if this is the right 'community' to post this. I did not find one for "SAS Information Map Studio". If this is incorrect, please let me know where I should post this question.
I have created a map and I need to create a filter on one of the date data items. In the map, I want the filter to be 'Begin_dt <= current_date' and End_dt >= current_date'. I tried to build a filter by selecting 'New filter', I selected the data item "Begin_Dt", for the condition I selected "Is before or equal to", for Values I selected 'use and expression', then in the expression I used the date funtion so my expression looks like this <<Demographics.Begin_Dt>> <= DATE() and << Demographics.End_date >= DATE()>>. I get an error that says "is invalid and cannot be used in a query".
Can you tell me what I am doing wrong? Or, is this something I can not do in Information Map?
01-18-2012 10:20 AM
I'm not sure if the logic you are using is going to work in the way you are expecting.
Anyway - if the experession is a cut and paste - then here's what's wrong:
The operator and DATE() are in the wrong place.
<<Demographics.Begin_Dt>> <= DATE() and << Demographics.End_date >= DATE()>>
The ">>" needs to be behind the data item.
<<Demographics.Begin_Dt>> <= DATE() and << Demographics.End_date>> >= DATE()
Subscribed to my BI Notes for SAS Users Blog for tips and tricks using the SAS BI toolset