Hello All, I am Hana. I am running SAS 9.4 M2 on Linux Server. Currently, having trouble with spanning header.   I included my code and outputs- What I have and What I want.   If you could help with this problem, I'd really appreciate it.   Thanks. Hana     options formchar="|----|+|---+=|-/\<>*"; What I Have Currently What I Want %macro generate_excel_tables(run_env=); %let excel_file_name = %str(ods_excel_ouput_&run_env..xlsx); %if &run_env. = %str(windows) %then %do; %let excel_file_out = %str(C:\Users\Reed_H\Downloads\TEMP\&excel_file_name.); /* windows */ %end; %else %do; %let excel_file_out = %str(/home/reedh/reedTest/data/output/&excel_file_name.); /* linux */ %end; ods listing close; ods escapechar='^'; options leftmargin=0.35in rightmargin=0.35in topmargin=0.75in bottommargin=0.75in papersize=letter ; ods excel file = "&excel_file_out." options (embedded_titles='yes' embedded_footnotes='yes' orientation='landscape' print_header_margin='0.3' print_footer_margin='0.3' print_footer="Page &P of &N" ) ; title font='Times New Roman' justify=left h=11pt color=black "****** ODS EXCEL ******** "; ods excel options(row_repeat='1-6' scale="80"); proc report data=sashelp.citiqtr(obs=1) nowd split = '*' style(report)={rules = all frame = box} style(header)={font_face = "times new roman" font_size = 10pt font_weight = medium font_style = roman foreground = black background = white just = c vjust = c bordertopcolor = black borderbottomcolor = black borderleftcolor = black borderrightcolor = black bordertopwidth=5 borderbottomwidth=10} style(column)={font_face = "Albany AMT" font_size = 10pt font_weight = medium font_style = roman foreground = black background = white bordertopcolor = black borderbottomcolor = black borderleftcolor = black borderrightcolor = black} ; columns bpb bpcr ("^S={borderleftcolor=red borderrightcolor=red borderleftwidth=10 borderrightwidth=10}spanning header11" ("^S={borderleftcolor=red borderrightcolor=red borderleftwidth=10 borderrightwidth=10}spanning header21" gc gd) ("^S={borderleftcolor=red borderrightcolor=red borderleftwidth=10 borderrightwidth=10}spanning header31" gcdq gcq)) ("^S={borderleftcolor=red borderrightcolor=red borderleftwidth=10 borderrightwidth=10}spanning header12" ("^S={borderleftcolor=red borderrightcolor=red borderleftwidth=10 borderrightwidth=10}spanning header22" gdp gyd) ("^S={borderleftcolor=red borderrightcolor=red borderleftwidth=10 borderrightwidth=10}spanning header42" gdpq gydq)) ; define bpb / "Bal1"; define bpcr / "Bal2" ; define gc / "GC" style(header column)={borderleftwidth=10}; define gd / "GD" ; define gcdq / "GCDQ" ; define gcq / "GCQ" ; define gdp / "GDP" style(header column)={borderleftwidth=10}; define gyd / "GYD" ; define gdpq / "GDPQ" ; define gydq / "GYDQ" ; run; ods excel close; ods listing; %exit: %mend generate_excel_tables; %generate_excel_tables(run_env=linux) /* windows or linux */   ... View more