topic Re: Use Sas libname on Server(Remote) in SAS Programming

Use Sas libname on Server(Remote)

Santt0sh — Wed, 03 Aug 2022 19:40:17 GMT

Hi All,

I am using PC SAS 9.x and
trying to use a SAS libname (Local , Teradata or Oracle) in a SAS remote session.
I have tried assigning the Libname within the Rsubmit;
I'm still getting the libname not assigned Error:

I have SAS access interface to
DB2,Oracle,Teradata, PC Files, OFBC, and to MYSQL.

RSUBMIT;
Libname dbtmp teradata user = myname password = xxxxxx tpid = 'xxxxx' schema = 'aaaaaaa';

Libname Winlib 'local path';

Data winlib.emp;
Set tmpdb.employee;
Run;

EndRsubmit;

Re: Use Sas libname on Server(Remote)

SASKiwi — Wed, 03 Aug 2022 19:48:01 GMT

Please post the complete SAS log including all SAS messages of your RSUBMIT program.

Re: Use Sas libname on Server(Remote)

Tom — Wed, 03 Aug 2022 19:56:21 GMT

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;

Re: Use Sas libname on Server(Remote)

Santt0sh — Thu, 04 Aug 2022 17:06:33 GMT

Hi Tom!

Thank You for your response,
The Proc download is working fine with the libname assignments but when I m trying to take a count of the previously created dataset saved on the sas library.
I can use the previous created dataset from in Remwork by name it as prev or some other name. But one of my colleagues who was doing things manually doesn't like this or wants to see the same names datasets

I'm not sure how do I attach the logs to this post.

Re: Use Sas libname on Server(Remote)

Tom — Thu, 04 Aug 2022 18:08:15 GMT

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