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
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.
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.