topic Re: How to reduce the RTF file size in SAS Programming

How to reduce the RTF file size

ychen89 — Thu, 06 May 2021 18:32:03 GMT

Hi all,

I'm working on some projects which need to output a lot of graphs to a single RTF file. Two years ago the output of similar stuff is only about 7.5 MB, but now it goes to 140 MB. All the settings are the same.

Is there anyone know what happened to ODS RTF output that make the output file sooooo big?

Is there any way to reduce the size of the RTF file?

Thanks,

Ying

Re: How to reduce the RTF file size

LeonidBatkhan — Thu, 06 May 2021 18:46:57 GMT

Hi ychen89,

It could be because you are using a different image resolution. Check out this Controlling Image Resolution .

Try explicitly setting image_dpi, for example set it to

image_dpi=100

in your ODS statement.

Hope this helps.

Re: How to reduce the RTF file size

ballardw — Thu, 06 May 2021 18:54:47 GMT

Something changed but it is hard to tell what. An upgrade to SAS could change the definition of an ODS Style. A change there could affect things without you "changing settings". Similarly if you are now using a different style that can affect the file size somewhat.

If you are primarily making graphs one item that can have a significant effect is the DPI (dots per inch) that are used when creating graphs.

If you want to reduce the file size you could try on the ODS RTF destination statement setting the IMAGE_DPI to a lower value. The default is typically 200 so using Image_dpi=100 should reduce the file size significantly.

Another possibility is if you changed the size of graphs. That increases file size, as would adding more graphs.

Since we do not have your settings from 2 years ago, your data or your code you get a sort of generic response.

Re: How to reduce the RTF file size

ychen89 — Thu, 06 May 2021 19:15:55 GMT

I tried that. It's not working. The file size stay the same.

Re: How to reduce the RTF file size

ychen89 — Thu, 06 May 2021 19:21:42 GMT

I tried that it's not working. The file size stays the same.

The only size related setting is

ods graphics on/ width=5.67in; *resizes all images;

other setting used in the old code which I keep are:

ods tagsets.sasreport13(id=EGSR) gtitle gfootnote;

ods rtf style=aeci_rpt nokeepn file="....Graphs.rtf";

The style is predefined. Only change the some default color.

I even tried to use device=PNG, and the file size stay the same.

Re: How to reduce the RTF file size

ballardw — Thu, 06 May 2021 21:26:43 GMT

@ychen89 wrote:

I tried that it's not working. The file size stays the same.

The only size related setting is

ods graphics on/ width=5.67in; *resizes all images;

other setting used in the old code which I keep are:

ods tagsets.sasreport13(id=EGSR) gtitle gfootnote;

ods rtf style=aeci_rpt nokeepn file="....Graphs.rtf";

The style is predefined. Only change the some default color.

I even tried to use device=PNG, and the file size stay the same.

Show me where you set the Image_dpi that "did not work". And the LOG from when you ran that.

Re: How to reduce the RTF file size

ychen89 — Fri, 07 May 2021 10:58:15 GMT

code:

ods rtf style=aeci_rpt nokeepn image_dpi=100
file="\......Graphs.rtf";

Log:

244 ods rtf style=aeci_rpt nokeepn image_dpi=100
245 file="....... Graphs.rtf";
NOTE: Writing RTF Body file: ..........NC Graphs.rtf