XLS via ODS statements

Jaheuk — Thu, 30 Aug 2012 13:12:21 GMT

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

Re: XLS via ODS statements

Cynthia_sas — Thu, 30 Aug 2012 13:37:57 GMT

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

topic Re: XLS via ODS statements in ODS and Base Reporting

XLS via ODS statements

Re: XLS via ODS statements