Hi Cynthia and art297, So first of all here is test code that forms 4 test reports that approximate describe the problem: proc sql inobs=1; Create table tab1 as select * from sashelp.class ; quit; proc sql inobs=2; Create table tab2 as select name,sex,age from sashelp.class ; quit; proc sql inobs=1; Create table tab3 as select * from sashelp.class ; quit; proc sql inobs=3; Create table tab4 as select name,sex,age from sashelp.class ; quit; proc report data=tab1 nocenter; define name/style=[font_weight=bold background=white] order; run; proc report data=tab2 nocenter; define name/style=[font_weight=bold background=white]; rbreak after/summarize; run; proc report data=tab3 nocenter; define name/style=[font_weight=bold background=white]; run; proc report data=tab4 nocenter; define name/style=[font_weight=bold background=white]; rbreak after/summarize; run; Here is results: Cynthia was right, I need these reports first in STP(stored process), and in next task will be export these reports to excel, but it's next task, I know that for ods excel proc report options are not active, but for now I should make "nice" view of these reports in Stored process application. Regarding reports, what I want to implement: Two first reports have different columns names, diff. column count, types etc., but they should be connected as it is one repoort, after second report should be simple sum calculation, that is applied only for second report. Then should be small break, and after this break next two reports should be conncected the same way as first two, these last two reports have same columns as first two, but can have different rows count. So target report I see similar to this image: I understand that such reports structure can be probably realized by one +-complicated proc report but the problem is that this reports will be changed very often, new subreports could be added to each of group etc, so I plan to create more flexible approach that will allow in loop build few simple proc report and merge them, so they look the same as one report.So if you have some ideas how to delete these few empty lines between reports- please let me know. Thanks for your answer in adwanced:)!
... View more