Here is how I code it using ODS Excel in EG7.1 on 9.4 platform: ods _ALL_ close; Ods noresults; options leftmargin = .25in rightmargin = .25in topmargin = .75in bottommargin = .5in papersize=LEGAL orientation=landscape ; ods escapechar="~"; ods Excel file="[filename].xlsx" Author="A_Seratte" style=SEASIDE; proc print data = ... label noobs; ODS Excel options ( sheet_interval="BYGROUP" sheet_name="#byval(office)" ...); title2 BOLD "&L&[tab]" ;  var...; by OFFICE ; run; ods Excel close; ods listing; ods results;   The&L left aligns it in Excel, though SAS will give you a warning or error message, and the &[tab] is straight from Excel. Comes out for me every time. ... View more