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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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