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: saving the macro variable’s value into a SAS dataset on the remote server; using EG’s “Download data files to PC…” task to download the dataset; using CALL SYMPUT to save the value to a macro variable in the local session. 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
... View more