Hi,
I want to invoke my SAS EG scripts using Excel VBA, i have searched a lot regarding this but as i am not very well versed with VBA programming i am facing issues. It would be great if anyone can guide me in this. thanks in advance.
Farrukh
Use SAS EG prompts to get parameters for execution.
http://support.sas.com/resources/papers/proceedings17/0818-2017.pdf
Why? Excel if a file format, not a development suite. If anything, drop the Excel part totally and do your work in SAS, outputting files for review.
I am building an excel interface in my automation tool. I will take few user inputs as macro variables in order to trigger SAS and calculate the desired outcome.
Use SAS EG prompts to get parameters for execution.
http://support.sas.com/resources/papers/proceedings17/0818-2017.pdf
What about the SAS Add-In to Excel? You can run EG reports directly this way without using VBA.
THANKS FOR YOUR REPLY, I WILL SURELY TRY THIS.
Look at this post to get you started:
Yours will be different since you want to go through EG. I think you should consider not having EG in the middle and submit to the SAS server directly. It is a lot easier. You need Integration Technologies client and you want to look at the workspace and the languageservice.
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.