BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
farrukh
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
6 REPLIES 6
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

farrukh
Calcite | Level 5

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. 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Use SAS EG prompts to get parameters for execution.

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

SASKiwi
PROC Star

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

farrukh
Calcite | Level 5

THANKS FOR YOUR REPLY, I WILL SURELY TRY THIS.

AlanC
Barite | Level 11

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.

https://github.com/savian-net

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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