BookmarkSubscribeRSS Feed
vicdicenzo
Obsidian | Level 7

I am trying to get my results output to Word. This has worked before but now I get the following error message. Can someone suggest how to solve this? Thanks.

 

ods rtf file = "/folders/myfolders/2017/RAPP/RAPPAHANNOCK 2017 CREEL RESULTS.rtf"
99 ! BODYTITLE;
WARNING: BODYTITLE and BODYTITLE_AUX cannot be changed in mid document.
5 REPLIES 5
againreddy
Obsidian | Level 7

FYI...

Specify that the titles and footnotes are to be placed into the body of the RTF document and not into the header and footer sections BODYTITLE
Specify that the titles and footnotes are to be placed into the body of the RTF document and not into the header and footer sections. The titles and footnotes will also be placed into cells or tables. BODYTITLE_AUX
ballardw
Super User

If you have already started writing to the same ODS RTF file as it says, you cannot change the behavior of bodytitle or bodytitle_aux.

Either move that to the first reference of the ODS RTF or use another approach.

 

Is suspect "worked before" meant that you set the option on the first reference to a specific destination file and then closed the document.

 

If you need to place text into the body and have previously not set the bodytitle you might try adding ODS TEXT RTF statements or Proc ODS TEXT to simulate titles. You would want to make sure that you have used title; footnote; prior to that so that the current titles don't appear if not wanted.

vicdicenzo
Obsidian | Level 7

I do not understand either of these responses. What additional info can I provide to clear this up?

ballardw
Super User

@vicdicenzo wrote:

I do not understand either of these responses. What additional info can I provide to clear this up?


Post the log from the entire program.

Paste it into a code box opened with the forum's {I} menu icon.

vicdicenzo
Obsidian | Level 7
OPTIONS LS=100 PS=100 NOCENTER NODATE NONUMBER;

/** Import an XLSX file. **/

PROC IMPORT DATAFILE="/folders/myfolders/2017/RAPP/COVER.XLSX"
OUT=WORK.COVER
DBMS=XLSX
REPLACE;
RUN;

/** Import an XLSX file. **/

PROC IMPORT DATAFILE="/folders/myfolders/2017/RAPP/EFFORT.XLSX"
OUT=WORK.EFFORT
DBMS=XLSX
REPLACE;
RUN;

/** Import an XLSX file. **/

PROC IMPORT DATAFILE="/folders/myfolders/2017/RAPP/CATCH.XLSX"
OUT=WORK.CAT
DBMS=XLSX
REPLACE;
RUN;

PROC IMPORT DATAFILE="/folders/myfolders/2017/RAPP/OPINION.XLSX"
OUT=WORK.SOCIAL
DBMS=XLSX
REPLACE;
RUN;


ods rtf file = "/folders/myfolders/2017/RAPP/RAPPAHANNOCK RIVER CREEL RESULTS 2017.rtf" BODYTITLE;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1978 views
  • 0 likes
  • 3 in conversation