topic Re: blank/empty line before title in ODS and Base Reporting

blank/empty line before title

michael90 — Fri, 04 Jan 2013 08:16:58 GMT

How to remove this line before the title (I am using PROC REPORT)? I am using TAGSETS.RTF, but as far as I can remember the same blank appears in the margin when using normal ODS RTF (BODYTITLE probably off). I read something about PARSKIP, but removing this manually might be laborious because of there is no consistency for the amount of lines on a page (first page one less then so it overflows to the second messing up the layout, in subsequent pages it does not happen, probably because of the section/page breaks specified by BREAK AFTER pageno). I also read to make PARKSIP smaller by adapting it's STYLE.

Re: blank/empty line before title

Jagadishkatam — Fri, 04 Jan 2013 09:45:08 GMT

Hi Michael,

to resolve the issue i believe you can follow the below syntax

title1 "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";

proc report data=dataset_name headline headskip missing ls=133 and ps=47;

where ls=line size and ps =page size.

you can change them depending on your requirement.

Hope this will solve your problem.

Thanks,

Jag

Re: blank/empty line before title

michael90 — Fri, 04 Jan 2013 10:38:46 GMT

thanks for your suggestion, but varying those options does not have any effect in the RTF file (OUTPUT listing it does).

Re: blank/empty line before title

Jagadishkatam — Fri, 04 Jan 2013 11:12:02 GMT

Hi Michael,

Alternatively you can do this way to solve the problem

proc report data=dataset_name headline headskip missing ls=133 and ps=47;

column name of variables;

compute before _page_;

line @1 "title";

endcomp;

run;

you can change the column position by changing the number, this way i hope you can position the title where you want.

Thanks,

Jag

Re: blank/empty line before title

michael90 — Fri, 04 Jan 2013 13:16:41 GMT

when i use the compute before statement, title gets in the header of the table, the space / blank before the title still exists.

Re: blank/empty line before title

data_null__ — Fri, 04 Jan 2013 13:46:44 GMT

I think you will need to include example code that produces the problem.

Re: blank/empty line before title

Jagadishkatam — Fri, 04 Jan 2013 13:50:39 GMT

Hi Michael,

Sorry but i am a bit confused. even the jpg image you attached is not clear. So could you please take the screen shot once again and send it. Also give us an example to help you.

Thank you for your post.

Thanks,

Jag

Re: blank/empty line before title

michael90 — Fri, 04 Jan 2013 14:25:12 GMT

data temp;

do i = 1 to 10;

text='xxx';

pagenr=1;

output;

end;

run;

ods tagsets.rtf file="temp.rtf";

title 'listing - why empty line/parksip before this title?';

proc report NOWD DATA=temp HEADSKIP HEADLINE MISSING SPLIT='~';

COLUMN (pagenr i text);

DEFINE pagenr / ORDER ORDER=INTERNAL NOPRINT;

DEFINE i / ORDER 'number';

DEFINE text / ORDER CENTER WIDTH=7 'text';

BREAK AFTER pagenr / PAGE;

run;

ods tagsets.rtf close;

Re: blank/empty line before title

Cynthia_sas — Sat, 05 Jan 2013 15:11:55 GMT

Hi:

I see the line feed/carriage return you are referring to. I do not believe the style template will "touch" that line feed before the title. When I change the PARSKIP element in a style template, the space between the TABLES changes, but not the line before the title. I have turned on paragraph marks in Word for the attached screenshot so you could see the difference when setting PARSKIP to 1 pt. See the difference between #1 (with PARSKIP set to 1 pt) and #2 with the default value for PARSKIP.

This is probably a question for Tech Support, because either 1) you can't get rid of the line feed before the title or 2) the way to change it may be a template change, but it would mean changing the TAGSET template for TAGSETS.RTF (not the style template), which means you would have to know what event at the SAS end was causing the line feed or carriage return before the title.

Here's the snippet of RTF that ODS is writing for the #1 title. My guess is that whatever piece of code writes this section is putting an extra line feed into the RTF output file:

{\*\bkmkstart IDX}{\*\bkmkend IDX}

{\pard\par}

\trowd\trkeep\trqc\trgaph0

\pard\plain\intbl\sb10\sa10\sl-299\fs26\cf1\qc\i\f1\b{1) listing - why empty line before this title?\cell}

But I don't know enough about RTF control strings or how the template logic works to suggest a change.

cynthia

ods path work.tmp(update) sasuser.templat(update)
sashelp.tmplmst(read);

proc template;
     define style test2;
     parent=styles.rtf;
        style parskip / fontsize = 1pt;
     end;
run;

ods listing close;
options nodate nonumber;
ods tagsets.rtf file="c:\temp\line.rtf" style=test2
startpage=no options(doc='Help');
title '1) listing - why empty line before this title?';
proc report data=sashelp.class(obs=3) nowd;
run;

proc report data=sashelp.shoes(obs=2) nowd;
run;

ods tagsets.rtf close;

ods listing close;
options nodate nonumber;
ods tagsets.rtf file="c:\temp\default.rtf" style=rtf
startpage=no options(doc='Help') ;
title '2) Default Skip';
proc report data=sashelp.class(obs=3) nowd;
run;

proc report data=sashelp.shoes(obs=2) nowd;
run;

ods tagsets.rtf close;