ODS HTML output to Excel but Column Split to Two Lines

Reply
Occasional Contributor
Posts: 15

ODS HTML output to Excel but Column Split to Two Lines

I used ODS HTML to export my tables to SAS. But the columns were split to two lines as shown in the blow picture. Is there any way to fix this issue? Thanks!

ods html file='c:\Weizhong\work1\mis.xls' style=Printer;
PROC FREQ DATA = weiz.mis;
TABLES band_aum band_rev;
RUN;

 

PROC FREQ DATA = weiz.mis;
TABLES band_rev_:;
RUN; 
ods html close;

untitled.bmp

Super User
Super User
Posts: 6,499

Re: ODS HTML output to Excel but Column Split to Two Lines

Probably not without changing the template.

Why not just use TAGSETS.EXCELXP to generate XML formatted Excel files instead of opening an HTML file with Excel ?

Ask a Question
Discussion stats
  • 1 reply
  • 204 views
  • 0 likes
  • 2 in conversation