Hi: So I'm not sure what your asking about. Are you asking about the TITLE statement syntax? Or, are you asking about the header cells in your screenshot? To increase the width of the header and data cells in your output, you only need to change the DEFINE statement or the PROC REPORT statement. In the code below, I set a default cellwidth (or width) of .5in for all the headers and data columns in the PROC REPORT statement and then override that default to be different for selected columns, as shown in the screen shot. In my test program, I eliminated your TITLE statement in favor of showing only the cellwidth change. cynthia Options noQuoteLenMax; title; footnote; ods listing close; ods tagsets.msoffice2k_x file= "c:\temp\sample_MSO2K_X.xls" style=normal options (rotate_headers="-90" height="100" fittopage='yes' EMBEDDED_TITLES = 'YES' gridlines = 'yes' blackandwhite = 'yes' doc='help'); proc report data=sashelp.class nowd split= '*' STYLE(header)=[BACKGROUND=silver foreground=black font=("calibri",10pt) FONT_WEIGHT=BOLD width=.5in] style(column)={font=("calibri",10pt) background=white foreground=black width=.5in} style(report)={font=("calibri",10pt) }; column name age sex height weight; define name /display 'Behavioral Health Discipline' style(header)={width=.75in} style(column)={width=.75in}; define age /display 'Total Number of Professionals by Discipline During the Reporting Period' style(header)={width=1.25in} style(column)={width=1.25in}; define sex /display '04 - PRTF' ; define height /display 'Total Number with at least 1 Claim Filed During the Report Period' style(header)={width=1.0in} style(column)={width=1.0in}; define weight /display '02 Mental Hosp' ; RUN; ods tagsets.msoffice2k_x close; ods listing;
... View more