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