topic Re: Create page variable for proc report in SAS Programming

Create page variable for proc report

JillChen0131 — Tue, 10 May 2022 15:09:28 GMT

I have dataset as below: I need to add a page variable to break dataset into different pages for proc report. In the final report, each group in their own page, each page can only show 5 records, so one group may have one or more pages.

group subgroup count

1 A 8

1 B 6

1 C 4

1 D 3

2 E 10

2 A 9

2 B 8

2 D 7

2 F 6

2 G 5

... ... ...

Re: Create page variable for proc report

AMSAS — Wed, 11 May 2022 11:57:19 GMT

Is this what you are looking for?
See REPORT Procedure

data have ;
	do group=1 to 5 ;
		do subGroup=1 to int(ranuni(0)*3+1) ; 
			count=int(ranuni(0)*10) ;
			output ;
		end ;
	end ;
run ;

proc report data=have ;
	define group / order  ;
	define subGroup / display ;
	define count / display  ;
	break after Group / page ;
   

run;