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

[smywky]

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

[Kurt_Bremser]

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

[Vince_SAS]

Try changing From_Entered_Dt_min and From_Entered_Dt_max to simply From_Entered_Dt for both.

Vince DelGobbo

SAS R&D

[smywky]

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