BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ravindra2
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions
4 REPLIES 4
andreas_lds
Jade | Level 19

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.

ravindra2
Fluorite | Level 6

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;
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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);
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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-dat...

 

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

As such there is nothing to answer here currently.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1853 views
  • 2 likes
  • 3 in conversation