topic Re: Rtf format change in ODS and Base Reporting

Rtf format change

sasuser123123 — Tue, 24 Sep 2019 11:34:36 GMT

Hello!
I was saved a proc report data as a rtf file in a folder . but whenever I'm opening that file it shows as Excel report not rtf. And also footnotes are came at top of table..I don't know why it's happening
I'm used...
Ods listing close;
Ods rtf file='path';
Proc report data=data;
.
.
.

.
Ods rtf close;
Ods listing;

Could you please help me out...

Thank you!

Re: Rtf format change

Cynthia_sas — Tue, 24 Sep 2019 13:55:31 GMT

Hi:

That is not what I observe -- as long as my path has a file extension of .RTF for the file I'm creating ODS RTF works fine for me. Here's my test:

As you can see, the RTF file opened in WORD correctly.

Cynthia

Re: Rtf format change

ballardw — Tue, 24 Sep 2019 14:41:23 GMT

If you have Excel opening an RTF document it may indicate that your Windows system has been set to open RTF by Excel.

Try this: use the Windows Explorer to navigate to the folder where you have saved the RTF file. Click on the RTF file to open it. If it opens in Excel then you need to change the default program used to open the RTF files.

Any behavior about footnotes would likely come from the Excel treatment of headers and/or footers which is different than Word.

Re: Rtf format change

sasuser123123 — Tue, 24 Sep 2019 15:22:12 GMT

Thank you for your responses!
Of course I was saved and opened my rtf file but it opened in Excel
Is there any options for changing....

Thank you

Re: Rtf format change

Cynthia_sas — Tue, 24 Sep 2019 15:42:31 GMT

Hi:

Go to Windows Explorer or File Explorer. Find the RTF file. Click once to highlight it, then Right-click to get a popup window, as shown below:

Under Open with you should see the applications that have been specified to open an RTF file. As you can see, on my system, I picked Notepad and Word as the 2 applications for RTF files. If you don't see Word as a choice in the Open with window, then you have to pick Choose another app. If you click Choose another app, then you should see some suggested other apps, like WordPad and Notepad, etc. Word should be in that list.

Hope this helps,

Cynthia

Re: Rtf format change

sasuser123123 — Wed, 25 Sep 2019 06:17:45 GMT

Thank you so much !!