topic sas eg excel to pdf in SAS Enterprise Guide

sas eg excel to pdf

amar8580 — Tue, 28 Feb 2017 16:39:03 GMT

hi all

i use filezilla to put a excel onto the server

in my program i bring in the file as follows

x cp /users_ac/amardeep.singh/Daily_Results_Template.xlsx %sysfunc(pathname(work))/Daily_Results_Template.xlsx;

then import some data into that excel tab

is there a way to then convert that into a pdf or its not possible in sas eg

Kurt_Bremser — Tue, 28 Feb 2017 17:28:12 GMT

ODS has a pdf destination that lets you print all SAS output to a pdf file.

Reeza — Tue, 28 Feb 2017 20:40:14 GMT

Not within EG, but with the X command enabled you can automate it using a VB script or VBA.

Excel can 'print' to a PDF directly and if you automate that step with a VB script or a macro embedded into the worksheet.

Or as mentioned,

export your results directly to a PDF file.

amar8580 — Wed, 01 Mar 2017 13:34:38 GMT

thanks

do you have an example as to how to call a vb script using x command

so i create a excel file that has macro in it and within sas call that macro

if i can get an example or sample code as to how to call vbscript or macro

it would be really appreciated

Kurt_Bremser — Wed, 01 Mar 2017 13:43:44 GMT

With LibreOffice, one can do it from the commandline:

path_to_libreoffice/soffice --convert-to pdf [--outdir target_directory] File(s)

But that's software from people who have a clue.