BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Azeem112
Quartz | Level 8

Dears,

 

I'm working on a report that has a date parameter.

 

WhatsApp Image 2020-10-09 at 12.04.48 PM.jpeg

 

There is a calculated field as

IF ( 'date'p <= 'date_of_offense'n )
RETURN 'Open'
ELSE 'Close'

Now I'm trying to pass this date parameter via URL but the report isn't picking the date value from the URL.

 

to even test it, I created a control dropdown of data_of_offense date column and assigned the date parameter in role tab. 

WhatsApp Image 2020-10-09 at 12.04.17 PM.jpeg

but whenever I send parameter via URL, the report doesn't update the value of the parameter from URL and also don't set the value of dropdown control, instead it does all the calculation using the default value of parameter that is 1Jan1960.

 

Below is the URL 

 

http://sasbap.demo.sas.com/SASVisualAnalyticsViewer/VisualAnalyticsViewer.jsp?reportPath=%2FShared%2...

 

I've tried many formats like 

date='12Jun2014'd

date=06/12/2014

date=12/06/2014

date=2014-06-12

date=2014-6-12

date=2014/06/12

date='06/12/2014'D

 

but report is not assigning the value of date parameter from URL to parameter. 

 

How can I pass the date value to the date parameter in SAS VA from URL. any help is appreciated.

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee

Hello,

 

I believe that the date value must be expressed as a numeric. The dates in VA are "SAS Dates", the number of days since 01JAN1960.

 

Try date=19886 to specify 12JUN2014.

 

You might find this page useful:

https://www.sastipsbyhal.com/2012/01/sas-date-calculator-now-available.html

 

You appear to be using VA 7.x? On Viya we have a URL generator UI that enables you pick the parameter values.

 

Sam

View solution in original post

2 REPLIES 2
Sam_SAS
SAS Employee

Hello,

 

I believe that the date value must be expressed as a numeric. The dates in VA are "SAS Dates", the number of days since 01JAN1960.

 

Try date=19886 to specify 12JUN2014.

 

You might find this page useful:

https://www.sastipsbyhal.com/2012/01/sas-date-calculator-now-available.html

 

You appear to be using VA 7.x? On Viya we have a URL generator UI that enables you pick the parameter values.

 

Sam

Azeem112
Quartz | Level 8
Thanks, It's working

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1352 views
  • 0 likes
  • 2 in conversation