topic Re: Proc Report about "\n" in SAS Programming

Proc Report about "\n"

Bill3 — Tue, 03 Sep 2024 07:53:21 GMT

data class; set sashelp.class sashelp.class; run; options nodate nonumber orientation=portrait missing=""; ods rtf file="yourpath.rtf" style=Journal; proc report data=class headline headskip nowd; run; ods rtf close;

After the proc report, there is a forced line breaks (maybe "\n").

Is there a way to not output this line break in the proc report? Because This will take up a row of space.

Re: Proc Report about "\n"

Ksharp — Tue, 03 Sep 2024 09:05:38 GMT

Try to use TAGSETS.RTF + options(vsspace='no') :

data class; 
set sashelp.class sashelp.class;
run; 
title;
ods tagsets.rtf text= 'xxxx';
options nodate nonumber orientation=portrait missing=""; 
ods tagsets.rtf file="c:\temp\temp.rtf"  style=Journal options(vsspace='no' CONTINUE_TAG='no'); 
proc report data=class headline headskip nowd; 
run; 
ods tagsets.rtf close;

Re: Proc Report about "\n"

ChrisNZ — Tue, 03 Sep 2024 23:19:34 GMT

@Ksharp 👍

I swear it's impossible to know about all the ODS options and capabilities unless you stumble upon them and save a note somewhere.

vsspace is not described on this page where it should be.

ODS has grown over the years, especially after the tagsets came along. There are now multiple ways to do things, with each method having different abilities and limitations. SAS should clean this up, pick a destination that can do it all and let the other destinations become obsolete, and document that destination properly. The ~~worst~~ most prolific is the relationship with Excel, as @ChrisHemedinger briefly demonstrated.

Re: Proc Report about "\n"

Ksharp — Wed, 04 Sep 2024 00:27:59 GMT

Agree. But that might be a big obstacle for sas.
you can check all the option of tagsets.rtf by :
ods tagsets.rtf options(doc='help');

Actually I learned this option vsspace='no' is from @Cynthia_sas , I also have no time to go throught all these options of all these ODS destinations.

Re: Proc Report about "\n"

Bill3 — Wed, 04 Sep 2024 05:17:57 GMT

I need to output this RTF when making TLFs for FDA Submission. So, what is the difference between ods tagsets.rtf and ods rtf? What extra precautions should I take when using the ods tagsets.rtf.

Re: Proc Report about "\n"

ChrisNZ — Wed, 04 Sep 2024 06:00:41 GMT

@Ksharp There's no vsspace in the help either.

There's this though:

 VSPACE: Default value is 'yes'.
      Current Value: on
      Usage: OPTIONS(VSPACE='yes')
      Description: 
        uses the PARSKIP event to place a space table in the document.
        'yes' and 'on' have the same action.
        Assigning 'no' or 'off' uses no PARSKIP table.

which is hardly helpful. It might be the same as vsspace who knows.

It's a mess. 😞

Re: Proc Report about "\n"

ChrisNZ — Wed, 04 Sep 2024 06:02:32 GMT

@Bill3 See here:

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-RTF-versus-ODS-TAGSETS-RTF/td-p/17704

@Cynthia_sas details the differences.

Re: Proc Report about "\n"

Ksharp — Wed, 04 Sep 2024 06:06:59 GMT

Yes. It is the same option since the LOG did not complain it by WARNING or ERROR.
SAS has some intelligence to know those are the same option .

Re: Proc Report about "\n"

ChrisNZ — Wed, 04 Sep 2024 06:13:37 GMT

Mmm the usual message for fixing typos is not there, like

WARNING 1-322: Assuming the symbol RENAME was misspelled as RENAEM.

Re: Proc Report about "\n"

Ksharp — Wed, 04 Sep 2024 06:33:04 GMT

Yeah. Maybe "vsspace" is just alias of "vspace" which is not documentation in.
For example: P= is same with PREDICTED= :
proc glm data=sashelp.class;
model weight=height;
output out=out predicted=pred;
quit;

proc glm data=sashelp.class;
model weight=height;
output out=out p=pred;
quit;

Re: Proc Report about "\n"

ChrisNZ — Wed, 04 Sep 2024 06:47:44 GMT

True. Fair point. If only there was some documentation to look this up...

Re: Proc Report about "\n"

Bill3 — Thu, 05 Sep 2024 01:55:50 GMT

thank u very much@!