topic Re: Proc report break row in SAS Enterprise Guide

Proc report break row

Daily1 — Fri, 08 Jul 2022 11:48:41 GMT

proc report data=sashelp.shoes nowd;
	column ('region'  region ) ('Product'  Product) ('Subsidiary'  Subsidiary);
	define Region / '' order=data;
	define Product / '' order=data;
	define Subsidiary / '' order=data;
run;

i have this output

i want this type of output

Re: Proc report break row

Ksharp — Fri, 08 Jul 2022 12:48:01 GMT

proc sort data=sashelp.shoes out=have;
by Region Product Subsidiary;
run;
data have;
 set have;
 if mod(_n_,11)=1 then group+1;
run;
proc report data=have nowd;
	column group ('region'  region ) ('Product'  Product) ('Subsidiary'  Subsidiary);
	define group/group noprint;
	define Region / '' order=data;
	define Product / '' order=data;
	define Subsidiary / '' order=data;
	compute before group/style={just=l fontweight=bold};
      temp=cats('report',group);
	  line temp $20.;
	endcomp;
run;