topic Re: report in rtf file without row lines and column lines in SAS Programming

report in rtf file without row lines and column lines

ravindra2 — Tue, 27 Nov 2018 06:14:05 GMT

hi i am having sashelp.heart dataset i want to report in rtf file there should be no lines between variable name and variable values only border should be there. it should be done using proc report.

Re: report in rtf file without row lines and column lines

andreas_lds — Tue, 27 Nov 2018 07:28:43 GMT

Please post the code you already have, so that we have something to work with.

There are some pre-defined styles printing not the full grid. I can't remember which one it is.

Re: report in rtf file without row lines and column lines

RW9 — Tue, 27 Nov 2018 09:08:36 GMT

The quality of any response you get here will depend greatly on the quality of your question. Follow the guidance below the post a question button - show some test data in the form of a datastep:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Show what the output should look like. Show what code you have.

As such there is nothing to answer here currently.

Re: report in rtf file without row lines and column lines

ravindra2 — Tue, 27 Nov 2018 09:24:21 GMT

i removed lines now there is a new task that decimal places should be in a order like

N 3217 1986

mean 64.70 64.98

Std 3.594 3.556

Min 54.75 51.5

Max 76.5 76

options orientation=landscape;
ods listing close;
ods rtf file='D:\report\heart_task1.rtf' startpage=no style=journal;
ods escapechar='^';
title 'Demographic of heart with height';
proc report data=st2 style(report)={rules=none frame=hsides cellspacing=0 cellpadding=0}STYLE(header) = [foreground=black background=cxD9D9D9
 cellheight=.23in
borderbottomwidth=.5pt borderbottomcolor=black
bordertopwidth=.5pt bordertopcolor=black
borderleftwidth=.5pt borderleftcolor=cxD9D9D9
borderrightwidth=.5pt borderrightcolor=cxD9D9D9]
nowd;
column sex alive dead total;
define sex/display ' ';
compute sex;
if sex='Male' or sex='Female' or sex='N' or sex='Mean' or sex='Std' or sex='Min' or sex='Max' then do;
call define (_col_,'style','style={leftmargin=.30in}');
end;
endcomp;
define alive/display "Alive(N=&nvar1)" style(column)={vjust=middle};
define dead/display "Dead(N=&nvar2)" style(column)={vjust=middle};
define total/display "Total(N=&nvar3)"style(column)={vjust=middle};
run;
footnote 'Please add above values in the table';
ods rtf close;

Re: report in rtf file without row lines and column lines

RW9 — Tue, 27 Nov 2018 09:29:13 GMT

Quick google:

http://support.sas.com/kb/50/231.html

http://support.sas.com/kb/24/537.html

Or you could just use:

style(column)=(vjust=middle just=dec);