11-26-2015 07:41 AM
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.
11-26-2015 01:52 PM - edited 11-26-2015 01:52 PM
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.
11-26-2015 04:02 PM
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.