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
You can't start Excel on AIX. Excel is Windows-only.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.