topic Re: How do I delete spaces after PROC ODSTEXT for RTF Output file in SAS Programming

How do I delete spaces after PROC ODSTEXT for RTF Output file

TBerlin2020 — Thu, 11 Jun 2020 13:46:18 GMT

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:

Thank you.

Best wishes,

Tanja

Re: How do I delete spaces after PROC ODSTEXT for RTF Output file

ed_sas_member — Thu, 11 Jun 2020 15:52:12 GMT

Hi @TBerlin2020

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

Re: How do I delete spaces after PROC ODSTEXT for RTF Output file

TBerlin2020 — Fri, 12 Jun 2020 05:40:17 GMT

@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;

Re: How do I delete spaces after PROC ODSTEXT for RTF Output file

ChrisNZ — Fri, 12 Jun 2020 07:03:39 GMT

Shouldn't you replace

{&TOC1.} \par

with

{&TOC1.}

Re: How do I delete spaces after PROC ODSTEXT for RTF Output file

TBerlin2020 — Fri, 12 Jun 2020 07:27:30 GMT

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

Re: How do I delete spaces after PROC ODSTEXT for RTF Output file

ChrisNZ — Fri, 12 Jun 2020 08:02:26 GMT

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

Sorry no more ideas 😞