topic Batch Export to Excel in SAS Enterprise Guide

Batch Export to Excel

Kenny — Mon, 08 Dec 2008 21:59:27 GMT

Can the EG Export to Excel be put in a batch job? I don't see any code generated, so I'm assuming it can't.

Re: Batch Export to Excel

Cynthia_sas — Tue, 09 Dec 2008 00:07:06 GMT

Hi:
If you are exporting DATA (like SASHELP.CLASS) to Excel, then you can do that in a BATCH job using PROC EXPORT.

If you want to get your procedure RESULTS (the results of a PROC MEANS, for example) into Excel then you have 2 choices:
1) create an output data set from PROC MEANS and then EXPORT the data set with PROC EXPORT
or
2) use ODS HTML, ODS MSOFFICE2K or ODS TAGSETS.EXCELXP to create an output file that Excel can open and render in Worksheet form.

You may have to type code into a CODE node or otherwise set up the code to run as a batch job. There are many examples of this in the SAS documentation.

cynthia

Re: Batch Export to Excel

Kenny — Tue, 09 Dec 2008 20:46:59 GMT

Thanks,

I was trying to write it from a Linux server SAS dataset to a Windows share. I can use the csv DBMS, but then I still have to move the file to the Win platform.

Maybe I can shell out of SAS and run an FTP or something.

Re: Batch Export to Excel

Cynthia_sas — Wed, 10 Dec 2008 15:39:15 GMT

Hi:
If you have SAS/Access to PC files, then you can use the LIBNAME engine for PCFILES in the manner shown here:
http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a002644677.htm

with path=, port= and server= options. This should work in a batch job, as long as all the network widgets are working and connected when the batch job runs.

Otherwise, you may have to create the file as CSV with PROC EXPORT (or using ODS TAGSETS.EXCELXP or ODS HTML) and then move the file.

cynthia

Re: Batch Export to Excel

nwitlou — Mon, 11 Jan 2021 07:57:50 GMT

Cynthia, i don't know if you are still working with SAS but i have the following problem:

we using SAS/AF - SAS9.4 on AIX in batch (ODS TAGSETS.EXCELXP ). after selecting data we want to export it into an excel file. we are using the code:

/* Load ole object */
hostcl=loadclass('sashelp.fsp.hauto');
/* Start excel application */
rc=hostcl._new(excelObj,0,'Excel.Application');

but after the hostclass is set the job stops while excecution the next command - start excel application, without a warning/error etc

it used to work, but we changed servers, ms excel (version 2013) and sas9.1 into sas9.4

did we miss some settings in excel/sas?

can you help us out?

why is the excel file not written?

this problem in only when we are using it within a batch job using automic 4.

Nicolet

Re: Batch Export to Excel

Kurt_Bremser — Mon, 11 Jan 2021 10:32:18 GMT

You can't start Excel on AIX. Excel is Windows-only.