Hi SAS-perts! I have successfully created an UI using SAS Stored Processes in EG environment - Involving creating session, passing macro variables within a session, creating custom HTML forms, updating the form with user inputs, drill down reports-etc. Thanks for the inputs from the SAS community as and when required. (Thanks to FriedEgg,  Filipvdr, milts, ballardw, NN, Juan Luis Sánchez Hernández.. Sorry If I missed anybody who helped me..Ofcourse SAS TechSupport) My current problem is - I have special characters in macro variable values. Initially I have suppressed '&' and apostrophe. It is passing the 'comma' character properly. When I pass AAAA, INC - it is passing correctly. But I realized that it is not passing the '+'.  When I pass 'days +3' and it ends up showing 'days 3'. I m not sure what other special characters it will not pass! Eventually I dont want to suppress any of the special characters and want to display them as such. Examples.    The variable has the following values.. which is being passes as _name.                          Wal&Mart                         Wal-Mart                         Wal'mart                         Wal,Mart Any help is appreciated! ... View more

Hi SASperts! I am looking to identify all the special characters( I am not sure what are the special characters) in a varaible value and suppress them dynamically?! I am working on a very large dataset! Any inputs?! Thanks SGB ... View more

I am creating a custom HTML form using STP in SAS EG. I have used some of the Jquery and JavaScript functionality! Before getting the desired output I am getting a pop up window about the security warning.. Do you want to view only the webpage content that was delivered securely?. Everytime I had to click 'No'. How can I avoid this?. Also When I am trying to get a image from http://XXXXXXX" I have the same problem. BG ... View more

I have created 3 stored processes. I am running EG4.3, Executing in stored process server and it is running successfully. But I need to enter my username and password in each of the steps. To avoid that I used the Method 2 in the following link from SAS. http://support.sas.com/kb/14/545.html# passing username and password in the URL What am I missing here?! My first stored process is being output in the new browser? Is that a problem.? When it is drilled down to call another stp I am using the following URL .. as mentioned in the http://support.sas.com/kb/14/545.html# http://your.server:8080/SASStoredProcess/do? _program=/yourfolder/your+stored+process&_username=sasdemo&_password={sas001}bX1wYXNz When I click for drill down report I am being asked for username and password! Any suggestions?! ... View more

Hi SSP Experts! I have a problem with the following code. formattest.HTML looks great, but when I put the same code in SAS it doesnt produce the same output?. I have attached formattest.html, html output and SAS output. Can anyone tell me whats the problem with the below code?! %let stpname=XXX; data _null_;   format infile $char256.;   input;   infile = resolve(_infile_);   file print;   put infile; cards4; <FORM ACTION="&URL" METHOD="POST"> <INPUT TYPE="HIDDEN" NAME="_program" VALUE="&stpname"/> <INPUT TYPE="HIDDEN" NAME="_action" VALUE="EXECUTE"/> <style type="text/css"> #mystyle { border:10px solid black; border-collapse:collapse; background-color: #CCCCCC; font-family: "Calibri"; } #mystyle th { border:1px solid black; font-weight: bold; } #mystyle th.th1 { text-align: left; width: 200px; } #mystyle th.rightside { border:0px; width: 250px; } #mystyle td { border:1px solid black; } #mystyle td.off { border:0px; } input[type=text] { width: 100px; background-color: #FFFFFF; } </style> <table id="mystyle"> <tr> <th class="th1">FLIGHT</th>           <th>4TH QTR</th>           <th>1ST QTR</th>           <th>2ND QTR</th>           <th>3RD QTR</th>           <td class="rightside"> </td> </tr> <tr> <td class="off"> </td>     <td><input type="text" name="4qStart1" >-<input type="text" name="4qEnd1" ></td>     <td><input type="text" name="1qStart1" >-<input type="text" name="1qEnd1" ></td>     <td><input type="text" name="2qStart1" >-<input type="text" name="2qEnd1" ></td>     <td><input type="text" name="3qStart1" >-<input type="text" name="3qEnd1" ></td>     <td class="off"> </td> </tr> <tr> <td class="off"> </td>     <td><input type="text" name="4qStart2" >-<input type="text" name="4qEnd2" ></td>     <td><input type="text" name="1qStart2" >-<input type="text" name="1qEnd2" ></td>     <td><input type="text" name="2qStart2" >-<input type="text" name="2qEnd2" ></td>     <td><input type="text" name="3qStart2" >-<input type="text" name="3qEnd2" ></td>     <td class="off"> </td> </tr> <tr> <td class="off"> </td>     <td><input type="text" name="4qStart3" >-<input type="text" name="4qEnd3" ></td>     <td><input type="text" name="1qStart3" >-<input type="text" name="1qEnd3" ></td>     <td><input type="text" name="2qStart3" >-<input type="text" name="2qEnd3" ></td>     <td><input type="text" name="3qStart3" >-<input type="text" name="3qEnd3" ></td>     <td class="off"> </td> </tr> </table> </FORM> ;;;; run; SGB ... View more