proc report

unnati — Fri, 16 Feb 2024 18:42:44 GMT

%let pgm = l_test ;
ods tagsets. file = "&_output/&pgm..rtf;
proc report nowd data=class
 style(report)=[rules=none frame=void]
 style(header)=[background=white borderbottomcolor=black borderbottomwidth=2
 background=_undef_];
 col ('^S={borderbottomcolor=black borderbottomwidth=2} '
 ('^S={borderbottomcolor=white borderbottomwidth=2 } '
 '^S={borderbottomcolor=white borderbottomwidth=2 } ' name)
 ('^S={borderbottomcolor=black borderbottomwidth=2}this is spanned'
 ('^S={borderbottomcolor=black borderbottomwidth=2} A' age sex)
 ('^S={borderbottomcolor=white borderbottomwidth=2' _empty)
 ('^S={borderbottomcolor=black borderbottomwidth=2} B' weight height)));
 define _empty/' ' style(column)={cellwidth=1% borderrightcolor=red
 borderrightwidth=5};
 compute after _page_ / style={bordertopcolor=black bordertopwidth=2};
 line ' ';
 endcomp;
run;
ods tagsets.rtf close;

Hello All,

I was trying to use proc report style option but some reason it is not been resolving. I have tried using data from sashelp library and attached is my output. Can anyone help why it is not resolving in my SAS EG ?

Re: proc report

PaigeMiller — Fri, 16 Feb 2024 19:13:22 GMT

I think you have left out ODS ESCAPECHAR

Here are the first four lines, which work for me

%let pgm = l_test ;
ods escapechar='^';
ods tagsets.rtf file = "abc.rtf";
proc report nowd data=class

PS: In the future, please do not attach files. Any time you need to show us output, make a screen capture and include it in your reply using the "Insert Photos" icon, which looks like a little camera. In particular, many people refuse to download Microsoft Office documents as they can besecurity threats.

topic Re: proc report in ODS and Base Reporting

proc report

Re: proc report