Running SAS 9.4 via VB script in excel

rramcharan — Thu, 07 Jun 2018 12:51:39 GMT

Hi there is there a simple way to open Base SAS v.9 from a VB script and run a pre- written sas program that needs parameters for macro's within the sas code?

I start SAS as :

"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -CONFIG "C:\Program Files\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg"

Thanks

Rob

Re: Running SAS 9.4 via VB script in excel

Kurt_Bremser — Thu, 07 Jun 2018 13:06:49 GMT

See the -sysin option for running SAS code in batch.

See -sysparm to hand parameters over to the code

If you store values in environment variables, you can use the sysget() and %sysget() functions to retrieve them.

topic Running SAS 9.4 via VB script in excel in SAS Programming

Running SAS 9.4 via VB script in excel

Re: Running SAS 9.4 via VB script in excel