The table headers produced by either of the following reports are the same, and are okay, except for the border appearance requirement as shown in the attachment. A 'verical merge' of the headers rows is possible by using DDE to set the borders, but unfortunately the production system will be on a platform where using DDE is not possible. ods tagsets.excelxp file='I:\dev\helpdesk\V2\test1.xls'; proc report data=t1 nowd; columns ('header one' v1 v2) v3 v4 v5; DEFINE v1 /display; DEFINE v2 /display; DEFINE v3 /display; DEFINE v4 /display; DEFINE v5 /display; run; ods tagsets.excelxp close; ods tagsets.excelxp file='I:\dev\helpdesk\V2\test2.xls'; proc report data=t1 nowd; columns ('header one' v1 v2) (' ' v3 v4 v5); DEFINE v1 /display; DEFINE v2 /display; DEFINE v3 /display; DEFINE v4 /display; DEFINE v5 /display; run; ods tagsets.excelxp close;
... View more