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.
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.