The SAS Output Delivery System and reporting techniques

XLS via ODS statements

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

XLS via ODS statements


dear all,

on SAS PC 9.2 I create an XLS with

ODS LISTING close;

ods html file="\\....\HU.xls" rs=none style=seasideprinter;

.....

ODS HTML3 close ;

ODS LISTING;

However, at the end of the program I always get the  POPUP box (with <open> <save>) after creation?

HOW to avoid this popup?

GreetZ,

Herman


Accepted Solutions
Solution
‎08-30-2012 09:37 AM
SAS Super FREQ
Posts: 8,864

Re: XLS via ODS statements

Hi:

  I notice that you open ODS HTML, but you close ODS HTML3? I assume that is a typo.

  I'm not sure what popup box you mean -- is this one of the Windows popups? I used to see one all the time with RTF or PDF output -- http://support.sas.com/kb/9/627.html

http://support.sas.com/kb/13/128.html

  Sometimes you can stop that from happening by going to Tools-->Options-->Preferences-->Results and turning OFF the "view results as they are generated" choice. But I haven't seen those type of messages in a while. But, as I said, I never saw this popup with ODS HTML output, so this is unusual.

  Or, if you have Excel 2007 or 2010, you might be seeing popup messages that says

"The file that you are trying to open "file" is in a different format than   specified by the file extension. Verify that the file is not corrupted and is from a  trusted source before opening the file. Do you want to open the file now?"

  This Tech Support note describes the note with ODS MSOFFICE2K and ODS TAGSETS.EXCELXP but you could also get it with ODS HTML or ODS HTML3:

http://support.sas.com/kb/31/956.html

  The reason for this second message is that when you use ODS HTML, ODS HTML3 or ODS MSOFFICE2K you are NOT creating a true, binary .XLS file in the proprietary Excel structure. You are merely creating an HTML file that Excel knows how to open and render. You are fooling the Windows registry into launching Excel when you double click because the registry has the .xls file extension associated with Excel. The true file extension for your file, when created with ODS should be .HTML or .HTM -- but then Windows would launch a browser.

  ODS is creating an HTML file for you. You name it .XLS to launch Excel. That does not change the underlying fact that if you open the file with Notepad you will see HTML tags.

  So, depending on what message you're seeing the fix might be one of two different things. If you're not seeing either of the above popup messages, then it might be good to work with Tech Support. If it is a popup that is new or a new situation, they can modify an existing note or issue a new note to help other folks.

cynthia

View solution in original post


All Replies
Solution
‎08-30-2012 09:37 AM
SAS Super FREQ
Posts: 8,864

Re: XLS via ODS statements

Hi:

  I notice that you open ODS HTML, but you close ODS HTML3? I assume that is a typo.

  I'm not sure what popup box you mean -- is this one of the Windows popups? I used to see one all the time with RTF or PDF output -- http://support.sas.com/kb/9/627.html

http://support.sas.com/kb/13/128.html

  Sometimes you can stop that from happening by going to Tools-->Options-->Preferences-->Results and turning OFF the "view results as they are generated" choice. But I haven't seen those type of messages in a while. But, as I said, I never saw this popup with ODS HTML output, so this is unusual.

  Or, if you have Excel 2007 or 2010, you might be seeing popup messages that says

"The file that you are trying to open "file" is in a different format than   specified by the file extension. Verify that the file is not corrupted and is from a  trusted source before opening the file. Do you want to open the file now?"

  This Tech Support note describes the note with ODS MSOFFICE2K and ODS TAGSETS.EXCELXP but you could also get it with ODS HTML or ODS HTML3:

http://support.sas.com/kb/31/956.html

  The reason for this second message is that when you use ODS HTML, ODS HTML3 or ODS MSOFFICE2K you are NOT creating a true, binary .XLS file in the proprietary Excel structure. You are merely creating an HTML file that Excel knows how to open and render. You are fooling the Windows registry into launching Excel when you double click because the registry has the .xls file extension associated with Excel. The true file extension for your file, when created with ODS should be .HTML or .HTM -- but then Windows would launch a browser.

  ODS is creating an HTML file for you. You name it .XLS to launch Excel. That does not change the underlying fact that if you open the file with Notepad you will see HTML tags.

  So, depending on what message you're seeing the fix might be one of two different things. If you're not seeing either of the above popup messages, then it might be good to work with Tech Support. If it is a popup that is new or a new situation, they can modify an existing note or issue a new note to help other folks.

cynthia

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 401 views
  • 0 likes
  • 2 in conversation