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.
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 |
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.
I do not understand either of these responses. What additional info can I provide to clear this up?
@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.
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.