cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12 DavidPhillips2
Rhodochrosite | Level 12
Go to Solution.

Information Delivery Portal 4.2 Prompts User Twice when using Post Back in a Stored Proc

Posted 01-28-2015 01:00 PM (1275 views)

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;

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
1 REPLY 1

SAS INNOVATE 2024

Innovate_SAS_Blue.png

 

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • ‎01-28-2015 01:00 PM
  • 1276 views
  • 0 likes
  • 1 in conversation