topic Re: pasting output in Word in SAS Studio

pasting output in Word

vicdicenzo — Fri, 03 Mar 2017 19:37:33 GMT

When I run my program, the output looks great in the browser. But when I paste the results into Word, the tables are very narrow and only fill about half the page. How can I adjust this with SAS code so that the results are easier to read when pasted into Word. Thanks.

Re: pasting output in Word

collinelliot — Fri, 03 Mar 2017 19:40:30 GMT

I would send my output to an RTF using the appropriate ODS statements. Then that file should have output that is far easier to put into Word.

For example:

ods rtf file = "YourPath\YourFileName.rtf";

Your SAS code to create output...

ods rtf close;

There's a lot you can do to customize your output to minimize how much you need to do manually after creating it, but that's another topic.

Re: pasting output in Word

vicdicenzo — Fri, 03 Mar 2017 19:42:56 GMT

Thanks. I am unfamiliar with that code? Where in the program does it go? Can you provide more details?

Re: pasting output in Word

collinelliot — Fri, 03 Mar 2017 19:55:46 GMT

Here's a simple example:

ods rtf file = "c:\my_sas_output.rtf";

proc print data = sashelp.class;

run;

ods rtf close;

You'd then go to Windows explorer to your C drive and open the file. Change the path and file name to reflect what you really want, of course.

Re: pasting output in Word

vicdicenzo — Fri, 03 Mar 2017 20:03:23 GMT

Thanks again - does that go at the very end of the code or up near the beginning where the files are brought in?

Re: pasting output in Word

collinelliot — Fri, 03 Mar 2017 20:06:53 GMT

Put the "sandwich" around whatever output you want to send the file.

Every output generated between the "ods rtf..." and "ods rtf close;" will end up in the specified file. So if you put the opening of the sandwich at the the top of the code and the ods close at the bottom, all generated output will go into that RTF. That might be more than what you want, of course. Also note that you'll also get the default output, too, unless you close other ods destinations.

Re: pasting output in Word

vicdicenzo — Fri, 03 Mar 2017 20:13:36 GMT

Thank you, I was able to get that to work. However, I lost all the titles to my output tables. Is there anyway to get those to print? Thanks.

Re: pasting output in Word

ballardw — Fri, 03 Mar 2017 20:19:49 GMT

Please show the code you ran.

ODS RTF by default will place title statements in the HEADER area of a Word document, or footnotes into the Footer area.

use option bodytitle to have the titles appear in the body of the document. Such as

ods rtf file="c:\path\myfile.rtf" BODYTITLE;

ods rtf close;

Re: pasting output in Word

collinelliot — Fri, 03 Mar 2017 20:21:23 GMT

See ballardw's comment below. That should do what you want.

Re: pasting output in Word

vicdicenzo — Fri, 03 Mar 2017 20:30:49 GMT

Thank you

Re: pasting output in Word

collinelliot — Fri, 03 Mar 2017 20:33:06 GMT

You're welcome. This is just the tip of the iceberg in terms of what you can do with ODS, so keep at it.