topic Data generates multiple times in RTF file in SAS Programming

Data generates multiple times in RTF file

Divya_Joseph — Fri, 21 Jul 2017 04:57:38 GMT

Hi ,

ODS RTF Body='C:\Users\Desktop\SASWorkshop\Q.rtf';
Proc Print Data=Cars;
Sum MSRP Length;
Where Make='Toyota';
Run;

It generates the data multiple times in RTF file. I have attached the screenshot also.

Can anyone tell me why I am getting multiple times.

Thanks

Re: Data generates multiple times in RTF file

Shmuel — Fri, 21 Jul 2017 05:49:24 GMT

Is this all your code or is it a part of the code?

@Divya_Joseph wrote:

Hi ,

ODS RTF Body='C:\Users\Desktop\SASWorkshop\Q.rtf';
Proc Print Data=Cars;
Sum MSRP Length;
Where Make='Toyota';
Run;

It generates the data multiple times in RTF file. I have attached the screenshot also.

Can anyone tell me why I am getting multiple times.

Thanks

Re: Data generates multiple times in RTF file

RW9 — Fri, 21 Jul 2017 08:18:07 GMT

That isn't the complete code is it, you haven't, for instance, got an ods rtf close at the end of the so the file gets written. Post the whole code, and the log if possible into code windows (this is using the {i} above the post area).

Re: Data generates multiple times in RTF file

Divya_Joseph — Sat, 22 Jul 2017 00:28:13 GMT

Hi,

It is not a part of code. This is the full code . Without using ODS syntax we just see the result in HTML view. So I am trying to store this into external file as RTF file. But when I execute this code I got result multiple times in RTF file. This code is fine in case of to store as exel,html and pdf.

Thanks

Re: Data generates multiple times in RTF file

RW9 — Mon, 24 Jul 2017 08:11:57 GMT

Do note my response - that is not the complete code. You are missing:
ods rtf close;

At minimum. Without that line of code you will not get a readable file. Please post full code.

Re: Data generates multiple times in RTF file

Divya_Joseph — Wed, 09 Aug 2017 06:32:24 GMT

It is working When I use ods rtf close;

Thank you