topic Re: in which case will the table or report be able to be exported to Powerpoint or word file? in SAS Studio

in which case will the table or report be able to be exported to Powerpoint or word file?

julieq8880 — Tue, 09 Oct 2018 02:27:38 GMT

Hi,

Will someone show me in which case will the table or report be able to be exported to Powerpoint or word file? also after Every "Proc...run;" ? Thanks!

Re: in which case will the table or report be able to be exported to Powerpoint or word file?

PGStats — Tue, 09 Oct 2018 03:25:03 GMT

Powerpoint and RTF are two destinations available in SAS Output Delivery System (ODS). When a destination is open, all procedure output is directed there by default. So, the statements

/* Open a destination */
ODS RTF file="c:\temp\myFile.rtf";

/* Create some output */
proc print data=sashelp.class; 
run;

proc univariate data=sashelp.class;
var height weight;
run;

/* Close the destination */
ODS RTF close;

will create a Word compatible file. There are lots of options in ODS to control which output goes to the destination and how it is formatted.

Re: in which case will the table or report be able to be exported to Powerpoint or word file?

CaseySmith — Tue, 09 Oct 2018 13:37:27 GMT

You can code the ODS statements explicitly as @PGStats showed, or you can check the RTF and/or PowerPoint options in EG's Tools->Options-Results->Results General->Result Formats, which will auto-generate the ODS statements for you in EG's generated wrapper code (which you can see in the log whenever you run code).

Casey