cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rajeeva
‎04-05-2017
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to stop titles to wrap in excel using sas ods html

by SAS Super FREQ in ODS and Base Reporting
‎04-01-2017 02:35 AM
‎04-01-2017 02:35 AM
Hi, I posted a response over here: https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-the-blank-rows-from-EXCEL-report-created-from-SAS/m-p/346133#U346133 You did not post the rest of your report. The macro program %print_report does NOT do anything by itself. You only show your titles. You don't show any code or what the rest of your report program looks like, how many columns you have on the report or how wide the report is.   As you can see from my example, below, HTML4 treats the title the worst. The other 3 destinations treat it better. I think that both ODS TAGSETS.EXCELXP and ODS EXCEL have ways to control the titles and how many columns that they span. You'd have to check more in the documentation. I still recommend that you switch to something other than ODS HTML.   cynthia ... View more

Re: How to remove the blank rows from EXCEL report created from SAS OD...

by SAS Super FREQ in ODS and Base Reporting
‎03-31-2017 01:26 PM
‎03-31-2017 01:26 PM
Hi: unfortunately, I am teaching today and unable to run code. Excel opening HTML is a tricky business. Just because you name the file as .XLS, it is not a true, binary XLS file. Excel is opening an HTML file and doing with it what it wants to do. If you were still running SAS 8, you would be using HTML3 with ODS HTML. If you are using SAS 9, then the default HTML created is HTML 4.0. How your Excel renders that HTML depends on Excel. One thing you could try is to switch to "microsoft friendly" html and use ODS MSOFFICE2K file="..."; ...code... ODS MSOFFICE2K close; That may make Excel happier. It may not. A fall back position would be to work with Tech Support. I can try to take a look when I'm not teaching, but Tech Support might be faster. cynthia ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-05-2017 03:52 PM
Quick links