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
Do a test run and let the SP write to a physical file instead of _webout, and then look at that.
Try changing From_Entered_Dt_min and From_Entered_Dt_max to simply From_Entered_Dt for both.
Vince DelGobbo
SAS R&D
Thank you for your advice, the issue has been resolved successfully.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.