Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to get date filter on two dates (start date and end date) in SAS VA

Reply
New Contributor
Posts: 4

How to get date filter on two dates (start date and end date) in SAS VA

[ Edited ]

Hello All,

I am new to the SAS VA and what i want to do is to create a report which filter my data on basis of two filter ,start date and end date.

I have tried the slider with date but it only gives me option to filter data on single date.

I also tried with two drop down but they are performing independent from each other and giving me output for that selected date,not for all dates inclusive.

 

Your help on this is appreciated.

SAS Employee
Posts: 31

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to rishi_1990

What version are you using?  There should be filter objects or properties that convert to a range (two sliders).

New Contributor
Posts: 4

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to rishi_1990
I am using SAS 7.3
I have tried plenty of options but not able to get it
SAS Employee
Posts: 31

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to rishi_1990

Is it 7.3 Designer or 7.3 Explorer?

New Contributor
Posts: 4

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to rishi_1990
It's SAS VA 7.3 designer
SAS Employee
Posts: 31

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to rishi_1990

When I add a slider to the report prompt area and add a date variable, it shows me a two-slider control use for filtering by range.  Similarly, when I add a date item as a filter to a specific object, the default control for this filter is a two-slider range.

 

How are you trying to set up the filter?

SAS Employee
Posts: 31

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to MikeJenista

Ah, wait, I think I understand.  Are you using two date items, one for start date and one for end date?  If that is the case I don't believe you can create a single filter control that sets both dates.  You could define a single advanced filter that uses an AND condition, or add two separate slider controls to set each date individually.

New Contributor
Posts: 4

Re: How to get date filter on two dates (start date and end date) in SAS VA

Posted in reply to rishi_1990
Yes ,you understand right..
Thank you for idea.
I will try that and share the results...
Ask a Question
Discussion stats
  • 7 replies
  • 219 views
  • 0 likes
  • 2 in conversation