BookmarkSubscribeRSS Feed
TBerlin2020
Calcite | Level 5

Hello,

 

I need to save analysis results in a RTF file including a navigation pane. Therefore, I used PROC ODSTEXT for section and table headings and PROC REPORT for the tables. However, there is too much space between the table heading and the tables. Is there a possibility to delete the spaces to have the table right below the table heading?  I was able to delete section and page breaks, however spaces were not deleted.

 

I highlighted spaces that should be removed in yellow:

 

TBerlin2020_2-1591883025191.png

 

Thank you.

Best wishes,

Tanja

5 REPLIES 5
ed_sas_member
Meteorite | Level 14

Hi @TBerlin2020 

 

Could you please share the portion of code you used? Best,

TBerlin2020
Calcite | Level 5

@ed_sas_member This is the Code:

 

ODS RTF
BODYTITLE_AUX
NOTOC_DATA
WORDSTYLE='(\h1 Title \s1 Heading 1 \s2 Heading 2 \s3 Heading 3 \s4 Heading 4 \s5 Heading 5 \s6 Heading 6 \date Standard)'
FILE="\\fs01\\04_BMT\SAS\RTF_Output\testOutput.rtf"
STYLE=Journal
STARTPAGE=YES;

 

PROC ODSTEXT;
p "{\pard\s1\b\fs24 {&Section2.} \par}" / style=[outputwidth=17.5cm fontfamily=Arial] ;
p "{\pard\s2\b\fs22 {&Section2_1.} \par}" / style=[outputwidth=17.5cm fontfamily=Arial];
p "{\pard\fs18 {Since no information available for non-enrolled women, tables will not be displayed by country.} \par}" / style=[outputwidth=17.5cm fontfamily=Arial];


p "{\pard\s3\b\fs20 {Section 2.1.1. Analysis Set: REC} \par}" / style=[outputwidth=17.5cm fontfamily=Arial] ;
p "{\pard\s4\b\fs18 {Subgroup: a-1 All Patients} \par}" / style=[outputwidth=17.5cm fontfamily=Arial] ;

%T02_01(AS=REC, STRATA=, SUBGROUP=, WHERE=, TOClevel=s5, TOC1=%STR({\b Table 2.1.1-1} &Table2_1.));

 

Macro %T02_01 creates the table as follows:


%macro T02_01(AS, STRATA, SUBGROUP, WHERE, TOClevel, TOC1);

* Global settings and formats;

proc datasets library=work kill nolist nodetails;quit;
title;footnote;

PROC ODSTEXT;
p "{\pard\&TOClevel.\fs18 {&TOC1.} \par}" / style=[outputwidth=17.5cm fontfamily=Arial] ; run;


* Data-Selection;

data ANALYSE;
set ADAM.ADSL;
&WHERE.
%SelectCohorts(AS=&AS., STRATA=&STRATA., SUBGROUP=&SUBGROUP.);
run;

 

*Creation of Table-data;

%OneWay(VAR=ENRFLN, NAME=ENRf., FORMAT=ENRf., LEVEL=%STR(-2,1,99999), WHERE=);

 

*Output: PROC REPORT ;

ods select all;
ods rtf startpage = NO;

proc report data=TAB_OUT nowindows split='*' missing
style={cellpadding = 3 cellspacing = 3};
column holder flag ("^S={textalign=l fontsize=8pt}&Tablecat." category) DUMMY;
define flag / order order=data noprint;
define category / '' order style(column)={cellwidth=11cm fontsize=8pt};
define STAT / '' missing style(column)={vjust=b textalign=r cellwidth=4cm fontsize=8pt};
define DUMMY / noprint;
define holder / group noprint;
break before holder / page contents="";
compute after _page_ ;
endcomp;
run;

ods rtf startpage = YES;

%mend T02_01;

ChrisNZ
Tourmaline | Level 20

Shouldn't you replace 

 {&TOC1.} \par

with

 {&TOC1.} 

TBerlin2020
Calcite | Level 5

@ChrisNZthanks for the suggestion. However, when I replace it the spaces are still there and a page break is included (see below)

 

TBerlin2020_0-1591946809118.png

 

ChrisNZ
Tourmaline | Level 20

I tested. I don't get the page break but still have the paragraphs.

Sorry no more ideas 😞

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
  • 5 replies
  • 1750 views
  • 0 likes
  • 3 in conversation