I am using SAS Information Delivery Portal 4.2 to display a stored procedure in a SAS Stored Process Portlet. I included a refresh button to update the stored procedure each time the user changes a dropdown option. The user experiences an extra login that I would like to remove.
First the user logs into SAS Information Delivery Portal 4.2 where the user is prompted for credentials. Then the user clicks on the tab containing the portlet. The stored procedure shows correctly. The user changes a dropdown parameter. The user clicks refresh. The stored procedure calls a postback method and reloads the page. Only on the first time the page refreshes is the user prompted for credentials, clicking refresh again will not prompt the user.
The post back call is:
PUT "<FORM METHOD='POST' ACTION='https://server1.com/SASStoredProcess/do'>";
The driver method is
/*driver function for displaying the form*/
%MACRO DisplayForm();
DATA _null_;
FILE _WEBOUT;
PUT "<html>";
PUT "<body>";
PUT "<div style='font-family: Verdana; font-size: 8pt;'>";
PUT "<CENTER>";
PUT "<FORM METHOD='POST' ACTION='https://server1.com/SASStoredProcess/do'>";
PUT "<input type='hidden' name='_program' value='/Users/User_Name/My Folder/Stored Procedure Name' />";
PUT "<input type='hidden' name='_action' value='EXECUTE' />";
DATA _null_;
file _webout;
PUT "<tr>";
PUT "<td colspan='2'>";
PUT "<input type='submit' style='font-family: Verdana; font-size: 8pt;' class='button' value='Refresh' />";
PUT "</td>";
PUT "</tr>";
Run;
%ProcessReport();
DATA _null_;
file _webout;
PUT "</table>";
PUT "</FORM>";
PUT "</CENTER>";
PUT "</div>";
PUT "</body>";
PUT "</html>";
file _webout;
RUN;
%MEND DisplayForm;
Used a url portlet instead.
Used a url portlet instead.
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 25. Read more here about why you should contribute and what is in it for you!
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.