The SAS Output Delivery System and reporting techniques

Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Accepted Solution Solved
Reply
Contributor
Posts: 37
Accepted Solution

Surpass the Excel prompts, with usage of Tagsets.ExcelXP

lAs I divert my outputs to XML files, I get a prompt (window named as File Download) whether to Open or Save or Cancel, which I really dont want to have.

Is there any option like NoPrompt or open_excel="no"? I'm using sheet_name=" " option as I got to load data into multiple tabs, dont know if this option is causing me all the trouble

Below is sample code

ODS TAGSETS.EXCELXP FILE ="C:\.....\FILENAME.XML";

TITLE        " Title for 1st sheet";

ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME="SUMMARY" EMBEDDED_TITLES="yes" ABSOLUTE_COLUMN_WIDTH='10,15,8,....');

   Proc Steps....

TITLE        "  ";

TITLE        " Title for 2nd sheet";

ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME="DATA" EMBEDDED_TITLES="yes" ABSOLUTE_COLUMN_WIDTH='10,15,8,....');

   Proc Steps....

TITLE        "  ";

ODS _ALL_ CLOSE;


I appreciate all valuable suggestions. Thanks in advance.


Accepted Solutions
Solution
‎09-27-2013 01:48 PM
SAS Super FREQ
Posts: 8,742

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Hi:

  I found it:

http://support.sas.com/kb/9/627.html

  Although this note references RTF and PDF specifically, I believe the fix is the same for any kind of external file (like the .XML file that you create with TAGSETS.EXCELXP) -- generally all of these files are opened with "3rd party" applications and this popup window is part of Windows behavior. You should NOT run into this issue in batch mode. You can verify with Tech Support, but I believe your only choice is the Windows Registry change.

cynthia

View solution in original post


All Replies
Super User
Posts: 17,784

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

If you go into SAS Menu Tools>Options>Preferences

Then on the results tab make sure the view results as they are generated is not selected.

Contributor
Posts: 37

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Thanks Reeza, Although this worked for me as of now, for some reasons the settings are not carried out for newer sessions. Also, now I'm worried of how it works with batch runs... may be I should look out for some options statement where I can have a complete control on this... Thanks once again.

SAS Super FREQ
Posts: 8,742

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Hi:

  I'm not at a place where I can search for Tech Support notes, but I believe there is a Tech Support note about this prompt. There is no suboption that I know of to suppress this prompt.

cynthia

Contributor
Posts: 37

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Thanks Cynthia, let me reach out to Support team..

Solution
‎09-27-2013 01:48 PM
SAS Super FREQ
Posts: 8,742

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Hi:

  I found it:

http://support.sas.com/kb/9/627.html

  Although this note references RTF and PDF specifically, I believe the fix is the same for any kind of external file (like the .XML file that you create with TAGSETS.EXCELXP) -- generally all of these files are opened with "3rd party" applications and this popup window is part of Windows behavior. You should NOT run into this issue in batch mode. You can verify with Tech Support, but I believe your only choice is the Windows Registry change.

cynthia

Contributor
Posts: 37

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Thanks very much Cynthia, this really helps and I think this should be the ultimate resolution for any such requirements. Great!!

Frequent Contributor
Posts: 96

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

This link is dead,  what did it say?

thanks

 

SAS Super FREQ
Posts: 8,742

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Sorry, looks like the Notes got restructured:
http://support.sas.com/techsup/notes/v8/9/627.html

cynthia
Frequent Contributor
Posts: 96

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

that's great- thanks!
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 9 replies
  • 1475 views
  • 4 likes
  • 4 in conversation