12-10-2016 01:16 AM
Dear all,
I'm submitting code remotely via
rsubmit;
And in one loop I'm running an if-else with a sysfunc to check if a local dataset exists then skip else continue with the loop.
%if %sysfunc(exist(local.qt&year.&month_1.&day_1._&modif.)) %then %GOTO reloop;
I spent debugging this for a while and the sysfunc executes perfectly if run locally but doesn't see that lib when run remotely -- code just runs as if files didn't exist. Prox download at the end of the loop however can download the remote dataset to the same local lib without a problem. All other code run remotely runs fine.
This should be something really obvious that I'm missing so any help would be appreciated!
Using SAS 9.4 M1 64 with EG 7.13 on a win 7 x 64 machine.
Arsenio
12-10-2016 02:25 AM
With SAS/CONNECT, the client has access to the server, but not vice versa. You need to evaluate the condition locally and transfer the result to the server (%syslput)
12-10-2016 09:12 PM
Agree with what @KurtBremser wrote.
One thought: In case your "local" SAS got also SAS/Connect licensed then another option would be to use remote library services within your rsubmit block
12-16-2016 09:26 PM
Only now could log back in -- apologies for a delayed answer. I will attempt the %syslinput approach, but it will take a while to write as I haven't used SAS macros in a while.
Thank you,
A