SAS Store Process: How to passing date range prompt via URL?

smywky — Tue, 27 May 2014 11:56:35 GMT

I had created a date range [From_Entered_Dt] prompt thru SAS SMC and would like to pass this variable in SAS Store Process (basically using SAS Foundation 9.3 script) via URL link.

When I tried pass the URL as followed:

'<a href="' || "%superq(_THISSESSION)"|| '&_program=' || "&_program" ||

%if %length(&save_asmt_period) > 0 %then

%do;

'&save_asmt_period' || '=' || urlencode("%trim(&save_asmt_period)") ||

%end;

%if %length(&VIEW_BY_DIM) > 0 %then

%do;

'&save_BY_DIM=' || urlencode("&VIEW_BY_DIM") ||

%end;

%if %length(&dim_point) > 0 or %length(&save_dim_point) > 0 %then

%do;

'&dim_point=' || urlencode("&save_dim_point") ||

%end;

'&LER_Type=' || urlencode("&LER_Type") ||

'&LER_Cap_Chrg=' || urlencode("&LER_Cap_Chrg") ||

'&LER_Cap_Chrg0=' || urlencode("&LER_Cap_Chrg0") ||

'&LER_Cap_Chrg1=' || urlencode("&LER_Cap_Chrg1") ||

'&LER_Cap_Chrg2=' || urlencode("&LER_Cap_Chrg2") ||

'&LER_Cap_Chrg3=' || urlencode("&LER_Cap_Chrg3") ||

'&LER_Conv_Islm=' || urlencode("&LER_Conv_Islm") ||

'&From_Entered_Dt_max=' || urlencode("&From_Entered_Dt_max") ||

'&From_Entered_Dt_min=' || urlencode("&From_Entered_Dt_min") ||

'&rpt=Y&_ODSDEST=RTF&_ODSSTYLE=sasweb' || '" target="rtf">' || "%sysfunc(sasmsg(sashelp.ormonrpt, RTF_output, NOQUOTE))" || '</a></p></center>';

Once click on the hyperlink following error message found:

Unable to execute stored process.

There is more than one parameter named “From_Entered_Dt_min” (possibly in a different case) present

Hope to get some advice from any expert here.
Thank you

Regard

Dave

Re: SAS Store Process: How to passing date range prompt via URL?

Kurt_Bremser — Tue, 27 May 2014 12:04:31 GMT

Do a test run and let the SP write to a physical file instead of _webout, and then look at that.

Re: SAS Store Process: How to passing date range prompt via URL?

Vince_SAS — Wed, 28 May 2014 14:01:04 GMT

Try changing From_Entered_Dt_min and From_Entered_Dt_max to simply From_Entered_Dt for both.

Vince DelGobbo

SAS R&D

Re: SAS Store Process: How to passing date range prompt via URL?

smywky — Fri, 20 Jun 2014 01:56:11 GMT

Thank you for your advice, the issue has been resolved successfully.

topic SAS Store Process: How to passing date range prompt via URL? in Developers

SAS Store Process: How to passing date range prompt via URL?

Re: SAS Store Process: How to passing date range prompt via URL?

Re: SAS Store Process: How to passing date range prompt via URL?

Re: SAS Store Process: How to passing date range prompt via URL?