BookmarkSubscribeRSS Feed
gabriel_k
Obsidian | Level 7

Hello,

 

I'm trying to execute SAS Stored Macros from the Excel with VBA. Have sometimes  failures of the listeners and couldn't really anderstand when it happends and what is the source of the problem, but usually when the SAS server is slow and I have a message that 'OLE is waiting fo SAS answer' on the other hand sometimes even having this message everything goes fine. 

How could i control the listener health? The problem is that I set up a loop checking if the execution is finished and having no answer from SAS make the loop endless and I don't know what is going on, cause when I check SAS processes are competed and everything went fine just I didn't get the event. It is the same On _StepError and _SubmitComplete listeners.

1 REPLY 1
ChrisBrooks
Ammonite | Level 13

Are you trying to call SAS via the VBA shell function or are you using the SAS Integrated Object Model (IOM)? I'd strongly recommend using IOM if you're using the shell function as I suspect the problem you're encountering may be due to startup time for the background SAS session that needs to be opened.

sas-innovate-2024.png

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.

 

Register now!

Discussion stats
  • 1 reply
  • 878 views
  • 0 likes
  • 2 in conversation