data shoes;
set sashelp.shoes;
run;
ods pdf file='c:\1.pdf';
proc report data=shoes split=' ' nocenter nowd style(REPORT)={cellspacing=0 cellpadding=2 background=white}
style(HEADER)={foreground=black font_weight=bold font_size = 1 just=center}
style(COLUMN)={foreground=black font_size = 1};
COLUMN region product subsidiary stores sales;
define region / group noprint;
DEFINE edcC / DISPLAY 'EDC' ;
DEFINE product / DISPLAY 'EDC' ;
DEFINE subsidiary / DISPLAY 'EDC' ;
DEFINE stores / DISPLAY 'EDC' ;
DEFINE sales / DISPLAY 'EDC' ;
compute before region / style=Header{just=l font_size = 1 font_weight=bold background=wheat};
before_line = catx(' ',trim(region));
line before_line $300.;
endcomp;
run;
ods pdf close ;
The above program writes output to a ODS destincation.
You can see in the same page there are multiple groups printed.
But the column headers are printed only once at the starting of the page and its not printed for each of the group if group starts in between pages.
I dont wnat skip the pages when group does not have more observation to print in that page.
Hopefuly this will help you in understanding.
... View more
