topic Re: How to pass date parameter in SAS Visual Analytics in SAS Visual Analytics

How to pass date parameter in SAS Visual Analytics

Azeem112 — Fri, 09 Oct 2020 07:34:35 GMT

Dears,

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

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.

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%20Data%2F&reportName=ParameterReport&date=06%2F22%2F2014

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.

Re: How to pass date parameter in SAS Visual Analytics

Sam_SAS — Fri, 09 Oct 2020 13:16:13 GMT

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

Re: How to pass date parameter in SAS Visual Analytics

Azeem112 — Mon, 12 Oct 2020 05:48:55 GMT

Thanks, It's working