topic Re: don't merge empty cells when title of proc report & ods excel (insert break/boundary) in ODS and Base Reporting

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

t_ar_taat — Fri, 15 Apr 2022 08:30:45 GMT

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.)

Thank you for your help.

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

t_ar_taat — Fri, 15 Apr 2022 09:07:32 GMT

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

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

t_ar_taat — Fri, 15 Apr 2022 09:27:14 GMT

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;