topic Re: Embed a chart into a word document in Microsoft Integration with SAS

Embed a chart into a word document

azorachase — Mon, 21 Nov 2016 20:46:28 GMT

Hello,

I would like to use proc sgplot to create a chart, and then embed the resulting graphic into a microsoft word document. Is there code that will automate this process (i.e., so I don't have to manually open up Microsoft word to enter the chart?).

Thanks for your help!

Re: Embed a chart into a word document

ballardw — Mon, 21 Nov 2016 20:50:54 GMT

ods rtf file='c:/path/yourdocumentname.rtf' ;

ods rtf close;

creates RTF that Word can open.

You may need to specify a style on the ODS RTF statement as the default for RTF may be gray scale, something like style=HTMLBlue or whatever.

Re: Embed a chart into a word document

azorachase — Mon, 21 Nov 2016 21:03:50 GMT

Thanks so much! Is there code to delete the date, time and page number that automatically appears in the RTF?

Re: Embed a chart into a word document

Reeza — Mon, 21 Nov 2016 21:05:51 GMT

Options nodate nonumber;