topic Re: pasting output in Word in SAS Programming

pasting output in Word

vicdicenzo — Thu, 25 Jan 2018 17:48:04 GMT

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.

Re: pasting output in Word

againreddy — Thu, 25 Jan 2018 18:11:25 GMT

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

Re: pasting output in Word

ballardw — Thu, 25 Jan 2018 18:18:43 GMT

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.

Re: pasting output in Word

vicdicenzo — Fri, 26 Jan 2018 00:40:04 GMT

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

Re: pasting output in Word

ballardw — Fri, 26 Jan 2018 16:37:41 GMT

@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.

Re: pasting output in Word

vicdicenzo — Mon, 05 Feb 2018 21:23:20 GMT

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;