I cannot figure out what you are asking about.
There is no reason you have to use a different member name as you did in your example.
proc download data=remote.member out=local.member status=n; run;
Or perhaps use the SELECT statement with the INLIB= and OUTLIB= options?
proc download inlib=remote outlib=local status=n;
select member1 member2;
run;
You might also want to look at the INHERITLIB= option on the SIGNON command.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/connref/p0brzkmxqg483hn163ek01h4mf6e.htm
Please post the complete SAS log including all SAS messages of your RSUBMIT program.
I assume you are trying to copy files from a libref that works on the REMOTE session to a libref that works on the LOCAL session. Why not use PROC DOWNLOAD? That is what it is for.
Libname Winlib 'local path';
rsubmit;
libname dbtmp teradata user = myname password = xxxxxx tpid = 'xxxxx' schema = 'aaaaaaa';
proc download status=n out=winlib.emp data=tmpdb.employee;
run;
endrsubmit;
I cannot figure out what you are asking about.
There is no reason you have to use a different member name as you did in your example.
proc download data=remote.member out=local.member status=n; run;
Or perhaps use the SELECT statement with the INLIB= and OUTLIB= options?
proc download inlib=remote outlib=local status=n;
select member1 member2;
run;
You might also want to look at the INHERITLIB= option on the SIGNON command.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/connref/p0brzkmxqg483hn163ek01h4mf6e.htm
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.