I would like to use Enterprise Guide to transfer the value of a macro variable on the remote metadata server into a macro variable on the local server. I connect to the metadata server via EG’s connection profile (i.e. I do not explicitly initiate a SAS/CONNECT session).
I know this can be done by:
This does not feel like an elegant solution, though. Could anyone suggest a better one? Ideally using this solution would not require the user to re-enter the user name and password since they are already saved in EG’s connection profile.
Many thanks!
Regards, Rok
Interesting question. Unfortunately I can't think of a better solution as EG treats the sessions to which it connects as entirely separate even if they are in the same EG connection profile so the only way to share information between them is via SAS datasets.
If EG and SAS server connections worked in a more ansynchronous manner like the way you can use SAS/CONNECT with PC SAS I suspect this would be possible but until then I suspect you will have to live with how you do it now.
EG tasks which allow to pipe data and macro variables directly from one EG session to another would actually be quite a nice extension to current EG functionality.
You could post this as an idea https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas
I'll vote it up.
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.