SAS Support Communities

Hi. Are you running this from a business machine where SAS is installed? Or a personal machine with no SAS installation (and SAS/Secure license)?  If the latter - you won't get this working - because of the encryption issue mentioned above by @Ksharp and @sxjeru .  (the nonpaid for version of SAS Integration Technologies doesn't include the TRIPLEDES encryption method) as commented on by @ChrisHemedinger above.   I did manage to make a connection to the SODA account using Python to execute SAS (a bit clunky but it worked in the end - there is more info at the bottom of the page in the link below) - here is the article that helped me get it working.    ... use Python to connect to SODA using the saspy package as described here: https://support.sas.com/ondemand/saspy.html#two   In summary - setup VS code to execute Python - download and configure the SASPy package to connect to SODA - execute a Python script that connects  and runs SAS code in SODA   Hope this helps. ... View more

H Chris.  I'm commenting here so that I get updated - in case a fix or workaround gets added - to get this working without a SAS/Secure license.  ... View more

Hi,   I realise this is an old question - but I had a similar question and found a workaround - so hope this helps going forward.    If you are using Enterprise Guide to view your SAS source code - then right click in the Program and select 'Copy HTML Source to Clipboard'. In Confluence choose to Insert Markup and change the dropdown in the Markup dialog from "Confluence wiki" to "Markdown" and paste your copied SAS source code from above.  Click Insert and then save your Confluence page and that will display your SAS source code with colour and formatting as displayed in Enterprise Guide.   Best regards, Graham. ... View more

Hi If you haven't managed to fix this drop me a line offline (email above...).  I'm not working with the stored process server at my current client (yet) but could maybe point you in the right direction if I could see the code. IIRC, I did something similar to your scenario by separating into 2 stored procs ... First stored proc runs the proc report and then used Don's macro to display a 'Continue' button after the proc report html. (The html in the button runs the second stored process which streams the CSV file ...) HTH, Graham. ... View more

Hi, This usage note from SAS describes a technique that may help you: http://support.sas.com/kb/19/475.html I found a reference to this in Phil Mason's paper -   http://support.sas.com/resources/papers/proceedings09/031-2009.pdf.   I think he presented an updated version at this years SGF. HTH ... ... View more

Hi, I got the style to change as follows: Turn OFF the automatic generation of Stored Process Macros: (on the SAS Code/"Include Code for" button while editing the Stored Process in EG.) Code the %stpbegin/end yourself: %global _odsstyle; %let _odsstyle = seaside; %stpbegin; %PleaseWaitExample; %stpend; It's a bit fiddly but it works. Another option is to rewrite the PleaseWait code with data _null_ and put statements and use a homegrown .css file. Email me at graham.murray@webminer.co.uk if you want me to send you the code I have. HTH, Graham. ... View more

Hi, Not strictly overwriting _webout but ... Take a look at Don Henderson's excellent blog article and example code here: http://www.sascommunity.org/wiki/Generating_Descriptive_Please_Wait_Messages_for_Long_Running_Stored_Processes The particular lines that 'switch off' the previous HTML output is here: %if &pleaseWaitCounter ne %then /* close/hide prior please wait wait message */ %str(ods html text = " pleaseWait&pleaseWaitCounter..style.display = ""none"" ";); I had some problems combining streaming HTML and then switching to Excel output but as long as you are displaying HTML throughout this should give you something to work with. Hope this helps, Graham. ... View more

Hi, Thanks for the reply. Yeah, I tried the window.close in the calling stored process and it did what you thought. (ie. closed the window before the stored process was called!) I am now trying as follows: (2nd stored process) data _null_; rc = stpsrv_header('Content-type','application/vnd.ms-excel'); rc = stpsrv_header('Content-disposition','attachment; filename=Temporary_Excel.xls'); run; ods tagsets.excelxp body=_webout style=minimal; proc print etc; run; ods tagsets.excelxp close; ods html body = _webout text="<a id=""Test"" onclick=""window.close();"">End</a>"; data _null_; put ; run; ods html close; When I call this stored process in debug mode I get the excel output in HTML and see the link ok which works as expected. HOWEVER, in normal execution I get the streaming output into Excel but no browser is displayed at all. Any additional suggestions gratefully received .... Thanks. Message was edited by: webminer ... View more

Thanks for your help, Vince. I was kind of hoping that you'd tell me that there was some kind of trick to force it to be recognised .... Never mind. Perhaps this could get added to the developers' New Year 'To Do List' ?! 🙂 Thanks for the snippet of code to get started down the other path, though. All the best for the holiday season and a good New Year when it comes, Graham. ... View more

It's 9.2 .... ... View more