BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello,

I'm using code given below to create stored process with output type set to streaming and browser is used to view the result.
How to suppress "Open Save As dialog box" prompt before opening excel file in browser so that result can be viewed in EXCEL without prompting user ?
%GLOBAL _ODSSTYLE _ODSDEST;
data _null_;
rc = stpsrv_header('Content-type','application/vnd.ms-excel;');
sysfunc(today(),date9.)).xls");
run;
%let _odsdest=tagsets.msoffice2k;
%LET _ODSSTYLE=normal;
%stpbegin;
proc print data=class;
run;
%stpend;

Warm Regards,
Mudit
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
If you were using the SAS Add-in for Microsoft Office for Excel, you could simplify your stored process (would not need STPSRV_HEADER call) and you would not get that dialogue box.

I do NOT think there's a way to suppress the dialogue box that you describe, however to find out for sure, you should contact Tech Support. There may be a registry method or a browser setting that affects whether a user gets prompted; however, if you change settings to accept this content (even though you know it is safe) you might be compromising the security on the browser because the browser might not respond appropriately if it received malicious content.

To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".

cynthia

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.

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
  • 612 views
  • 0 likes
  • 2 in conversation