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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.