Proc report output issue

Niugg2010 — Thu, 17 Sep 2020 15:49:00 GMT

I want to get the below output. However, when I run my below code I can not get the red marked part.

Is there anyone help me out?

Thanks a lot.

data x;
	do var1='A', 'B', 'C'; 	output;  end;

	do var1='A', 'B', 'C';
		do var2="aa",'bb', 'cc';
			output;
		end;
	end;

	do var1='A', 'B', 'C';
		do var2="aa",'bb', 'cc';
			do var3=1 to 20;
				output;
			end;
		end;
	end;
run;

data x;
	set x;
	length var4 $10;
	if missing(var2) then do; level=1; var4=var1; end;
		else if missing(var3) then do; level=2; var4=var2; end;
		else do; level=3; var4=strip(var3); end;
run;

proc sort data=x; by var1 var2 var3; run;
data x;
	set x;
	_page=ceil(_n_/25);
	keep _page level var4;
run;

ods rtf file="...\try.rtf";
proc report data=x;
column  _page level var4;
	define _page/ group noprint;
	define level/ display order=data noprint;
	define var4/display order=data;
	break after _page/page;
	compute var4;
		if level=2 then call define(_col_, "style", "style=[indent=0.5 in]");
		if level=3 then call define(_col_, "style", "style=[indent=1 in]");
	endcomp;
run;
ods rtf close;

Re: Proc report output issue

Niugg2010 — Mon, 21 Sep 2020 13:41:37 GMT

Thanks for your suggestion. Still I did not figure out how to get what I want.

topic Re: Proc report output issue in SAS Programming

Proc report output issue

Re: Proc report output issue

Re: Proc report output issue