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 :
Please let me know how i can attache the data set , as of now data attached in excel file.
Attached the data in a excel file and data set
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.