Thanks a lot, it's perfect ! ... View more

Thanks a lot Suzanne for this answer. I have another constraint in my table that I didn't mention and which explains the way I've decided to code that table.  I need different styles for headers "Measures" and Information". That's why in my SAS code I can specify a general header style in proc report which is applied to "Measures" and another header style in the define line for "Informations". How can I do that in your example ?   Thanks, ... View more

My table has an "across" statement and it seems to create a problem with spanrows. Here is an example of my SAS code with sashelp.class. data test2; set sashelp.class; id_num = "Information"; run; ods excel file="&export" options(sheet_name="test"); ods escapechar='~'; ods text="~S={font_size=14pt font_weight=bold vjust=m}~SAS Community"; ods text="~S={font_size=14pt font_weight=bold vjust=m}"; proc report data=test2 nowd  ;     column ('Measures' weight height)  id_num, (name age sex);     define weight / display ;     define height / display ;     define id_num / across '' ;     define name / display ;     define age / display  ;     define sex / display;     run; ods excel close;   Is there another way to have headers "Measures" and "Information" and also to have sex in merged cells like in your example ?   Thanks, ... View more