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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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