don't merge empty cells when title of proc report & ods excel (insert break/boundary)

[t_ar_taat]

When I use ods excel & proc report, cells of sequentialley empty in title is united.

I want to avoid this 3rd line in title.

data d_out;
 set sashelp.class;
 attrib col1 - col4 length = $20;
 call missing(of col1 - col4);
run;

ods excel file= "D:\test.xlsx";
proc report data=d_out(obs=3)
 split="#"
 out = _O_REP
;
    column 
  ("1" ("A" ("" ("" col1))))
  ("2" ("B" ("" ("" col2))))
  ("3" ("C" ("" ("" col3))))
  ("4" ("D" ("" ("" col4))))   
   age
    ;
    define col1 / display "";
    define col2 / display "";
    define col3 / display "";
    define col4 / display "";
   
    define age / display;
run;
ods excel close;

I want to insert break/boundary like this. (insert blank as dummy is also OK.)

Related QA = using across which I don' t use.
https://communities.sas.com/t5/ODS-and-Base-Reporting/Proc-Report-Create-Border-and-Title-should-be-...

Thank you for your help.

[t_ar_taat]

This doesn't work.
define col2 / display "" style(column)=[ tagattr="merge:no"];

[t_ar_taat · Accepted solution]

I solve it with split.

proc report data=d_out(obs=3)
 split="#"
 out = _O_REP
;
    column 
  ("1" ("A" ("" ("" col1))))
  ("2" ("B" ("" ("" col2))))
  ("3" ("C" ("" ("" col3))))
  ("4" ("D" ("" ("" col4))))   
   age
    ;
    define col1 / display "#";
    define col2 / display "#";
    define col3 / display "#";
    define col4 / display "";
    
    define age / display;
    
run;