The SAS Output Delivery System and reporting techniques

how to convert pdf outputs into rtf or excel

Reply
Occasional Contributor
Posts: 13

how to convert pdf outputs into rtf or excel

 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*/

Super User
Posts: 11,343

Re: how to convert pdf outputs into rtf or excel

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.

Ask a Question
Discussion stats
  • 1 reply
  • 183 views
  • 0 likes
  • 2 in conversation