Excel/VBA invoke SAS in Unix

[sarasara]

is there anybody know whether the SAS in Unix can be executed via Excel/VBA? pls give me some suggestions and clues, thanks!

 

[sous2817]

Hello and welcome to the board! Yes, I do it using a program called ActiveBatch. Basically VBA executes ActiveBatch, which then runs the SAS job.

 

[sarasara]

Thank you very much!
what is Activebatch? is it a VBA module or just a program?

 

[sous2817]

ActiveBatch is a program (http://www.advsyscon.com/products/activebatch/job_scheduling.asp) that sits on both the server and your local machine. Once installed on your local machine, you can set a reference to it, invoke an instance, and then pass a SAS job to the server through it. I don't know much about the server set up, that was in place before I started. If you'd like, I can post the relevant activebatch code that I use.

 

[sarasara]

Thank sous2817. I have no Activebatch program installed in my computer. . any other suggestions?

 

[sous2817]

ActiveBatch is a standalone product, so you'd have to purchase it. Depending on your structure, you can connect to the server where your SAS is located. I haven't tested that much because of our corporate server structure (and being required to use ActiveBatch). Here's the code:

Call Shell("""\\… server location …\sas.exe"" -nosplash -icon -sysin ""… SAS file name
…""", vbMinimizedNoFocus)

but I'm not going to be much help from here on out. Here's a link to a paper that may help you along:

http://www.lexjansen.com/phuse/2005/as/as11.pdf