Desktop productivity for business analysts and programmers

Invoking SAS EG using Excel VBA

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Invoking SAS EG using Excel VBA

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


Accepted Solutions
Solution
‎12-13-2017 02:10 AM
Super User
Super User
Posts: 9,857

Re: Invoking SAS EG using Excel VBA


All Replies
Super User
Super User
Posts: 9,857

Re: Invoking SAS EG using Excel VBA

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.

Occasional Contributor
Posts: 11

Re: Invoking SAS EG using Excel VBA

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. 

Solution
‎12-13-2017 02:10 AM
Super User
Super User
Posts: 9,857

Re: Invoking SAS EG using Excel VBA

Use SAS EG prompts to get parameters for execution.

http://support.sas.com/resources/papers/proceedings17/0818-2017.pdf

Super User
Posts: 4,030

Re: Invoking SAS EG using Excel VBA

What about the SAS Add-In to Excel? You can run EG reports directly this way without using VBA.

Occasional Contributor
Posts: 11

Re: Invoking SAS EG using Excel VBA

THANKS FOR YOUR REPLY, I WILL SURELY TRY THIS.

Regular Contributor
Posts: 150

Re: Invoking SAS EG using Excel VBA

Look at this post to get you started:

 

https://communities.sas.com/t5/Integration-with-Microsoft/Run-a-SAS-program-from-Visual-Basic-in-Exc...

 

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 213 views
  • 0 likes
  • 4 in conversation