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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.