topic Re: libname issue in SAS Programming

libname issue

JHE — Mon, 19 Aug 2019 18:41:28 GMT

run this:

LIBNAME mydata "/mnt/nfs/prod/Sched/OpsDeptData/Operations/ITSM/IMPORT/DATA";

log:

LIBNAME mydata "/mnt/nfs/prod/Sched/OpsDeptData/Operations/ITSM/IMPORT/DATA";
WARNING: Library MYDATA does not exist.
NOTE: Libref MYDATA was successfully assigned as follows:
Engine: V9
Physical Name: /mnt/nfs/prod/Sched/OpsDeptData/Operations/ITSM/IMPORT/DATA

run the code:

proc sql;
create table mydata.MIM1 as
select * from work.MIM1;
quit;

log:

28 proc sql;
29 create table mydata.MIM1 as
30 select * from work.MIM1;
ERROR: Library MYDATA does not exist.

why ?

Re: libname issue

Kurt_Bremser — Mon, 19 Aug 2019 19:18:25 GMT

This is your clue:

LIBNAME mydata "/mnt/nfs/prod/Sched/OpsDeptData/Operations/ITSM/IMPORT/DATA";
WARNING: Library MYDATA does not exist.

The SAS session can't find the directory. Mind that your workspace server might run on a remote machine that does not have the network share mounted.

Re: libname issue

JHE — Mon, 19 Aug 2019 19:44:36 GMT

Oh, I see, let me check.