topic Re: how to convert pdf outputs into rtf or excel in ODS and Base Reporting

how to convert pdf outputs into rtf or excel

Kinston — Tue, 30 Aug 2016 15:53:23 GMT

Hi experts,

the code below gives a pdf output to a printer but I want to change the output to word or excel.

can anyone help? if i need to change all the code can someone help me with the new code that can truly send an excel or rft output to a printer?

thanks.

%let device=PDFCT; /*to print pdf*/
/*%let device=LJIVPS; *//*to printer*/
%let targetdevice=LJIVPS; /*dont change the target device*/

goptions
targetdevice=&targetdevice
device=&device
%if %upcase(&device) eq LJIVPS or %upcase(&device) eq PDFCT %then %do;
gaccess=gsasfile
%end;
gunit=pct
rotate=portrait
nodisplay
;
%let page_count=39; /*one less then start page*/

Re: how to convert pdf outputs into rtf or excel

ballardw — Tue, 30 Aug 2016 20:18:12 GMT

You may need to provide more information but generally:

ods rtf file="c:\path\mydocname.rtf";

/* your procedures that generate output. NOTE: DO not direct output to devices directly*/

ods rtf close;

with put the output into an RTF file you specify with the file part of the ODS RTF statement that WORD can read.

Since you are using GDEVICE type statements it is hard to know what other setting you may have that effect output.

Depending on what you are doing you may have appearance issues at the end as ODS Styles will control many of the appearance options.