Proc Report Break and Group

raja777pharma — Thu, 02 Apr 2020 09:31:41 GMT

Hello Team ,

I am struggling to generate rtf based on group and break at specific lines in RTF

I would like to genrate RTF as per below screen shot

Want Output:

My Code is below TO genrate RTF

proc Report data=report split='^' missing nowd spanrows headline headskip ;
	column gpxpage paramn avisitn catno col1 col2 col3 col4 col5 col6 col7  ;
	define gpxpage	/order order=internal "" noprint;
	define paramn	/order order=internal "" noprint;
	define avisitn /order order=internal "" noprint;
    define catno /order order=internal "" noprint;

	define col1 /&Header  group style(column)=[cellwidth=1.2in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow;
    define col2 /"Parameter"  group style(column)=[cellwidth=0.8in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow;
    define col3 /"Statistics"   style(column)=[cellwidth=0.9in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow;
	define col4 /&Header1.   style(column)=[cellwidth=1in	font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on];
	define col5 /&Header2.  style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on];
    define col6 /&Header3.  style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on];
    define col7 /&Header99.  style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on];

	break after gpxpage / page;

	compute before gpxpage;
        line " ";
    endcomp;

run

My Current Output :

Key Points : The data should be sorting by : gpxpage paramn avisitn catno ,
The first COL1, COL2 to display Group and Break at COL2 after 'OBSERVER' and 'CHANGE' values
I have included in report only limit columns (in Expected RTF column 7,8,9 no need)

Please let me know how i can attache the data set , as of now data attached in excel file.

Re: Proc Report Break and Group

raja777pharma — Thu, 02 Apr 2020 00:44:41 GMT

Attached the data in a excel file and data set

topic Proc Report Break and Group in SAS Programming

Proc Report Break and Group

Re: Proc Report Break and Group