Format is preventing me from merging cells in excel

#Format is preventing me from merging cells in excel pdf
#Format is preventing me from merging cells in excel code

Ods msoffice2k file='somefile.html' style=sasweb ДЄnd one of 2 things will happen 1) either your output will look the same in the EG Results Viewer as it does in Excel (Yay!) or 2) your output will look different in the EG Results Viewer than it does when Excel opens the HTML file (Bummer!) Ods _all_ close /* close any 'automatic' EG open destinations */

#Format is preventing me from merging cells in excel code

One thing you can try is this - from a CODE node in EG: You can actually turn on the LISTING output in SAS EG, but folks don't do that very often - given that it looks plain, plain, plain.ДЄnd, you're right, because EG treats the output like a browser would treat the output (and not like Excel treats the output), you may or may not get the look you want in the EG Results Viewer. For EG, the Results Viewer simply surfaces the output - rendering it in whatever form (using whatever internal transformation or plug-in, it needs to use to load the output into the Results Viewer). When you use SAS EG, behind the scenes, you will see ODS statements being issued - if you look in the SAS log - you will see ODS HTML or ODS SASREPORT statements surrounding all your code. I apologize for not clarifying or asking the question about whether you were using EG or Display Manager. Hmmm.are you by any chance using SAS Enterprise Guide? I believe one of the default output types in SAS EG is HTML or SAS Report and in that case, the output is rendered as HTML or as though it is HTML and rendered as a browser would render it.ДЄnd, if you are using SAS EG, then the Results viewer is -different- from the LISTING destination/window. The only time you can use the STYLE= option with the LISTING destination is if you plan to create graphic output in SAS 9.2 and you want the GRAPH1 window or your ODS graph output to use the SAS Style template. The LISTING destination, on the other hand is plain text ASCII output - as far as tabular results go. XLS as the file extension), the style information is still HTML-based style info. Even if you open the HTML file with Excel (or name the file with.

The 2 files will look very different from one another because the STYLE= option sends appropriate HTML style information to the output HTML file.

#Format is preventing me from merging cells in excel pdf

Ods pdf file='see_journal.pdf' style=journal Ods rtf file='see_journal.rtf' style=journal Ods msoffice2k file='see_ocean.html' style=ocean Ods msoffice2k file='see_sasweb.html' style=sasweb You can alter the way your HTML (or other non-LISTING destination) output looks by using the STYLE= option in different destinations: For tabular output, the LISTING destination does not support the use of STYLE templates to control the look and feel of the output.

The LISTING destination is what controls the output or LISTING window.

ODS MSOFFICE2K is not an ODS STYLE- it is an ODS DESTINATION. If you think the PROC TABULATE approach is too kludgey, then you might try PROC REPORT - which has the advantage of not having the BOX area at the intersection of the Column header area and the Row header area. ODS HTML (and by extension, any of the HTML destinations - ODS MSOFFICE2K, ODS TAGSETS.MSOFFICE2K_X, ODS PHTML, ODS CHTML, ODS HTMLCSS, etc) were designed to be opened and rendered in a browser (first) or in other applications, such as Word or Excel that can open and render HTML tags. LST file or the SYSOUT file were the ONLY way of getting printable output from SAS. The results window or the LISTING window is a 'monospace' destination - that just means that output looks pretty much the same as it looked when SAS was originally created and the LISTING window, the.