topic Re: Library DBSDTM does not exist. in SAS Programming

Library DBSDTM does not exist.

Patelbb — Fri, 18 Jan 2019 02:14:37 GMT

Hi,

I was wondering if anyone was willing to help me with this. I ran the following and got a note that states that DBSDTM does not exist and I can't figure out why. Any assistance would be appreciated. Thank you!

105 libname dbsdtm 'C:\SAS 9.4\SAS-II Class\Raw Data\SDTM';
NOTE: Library DBSDTM does not exist.

Re: Library DBSDTM does not exist.

ChrisNZ — Fri, 18 Jan 2019 04:07:51 GMT

Does the directory

C:\SAS 9.4\SAS-II Class\Raw Data\SDTM

exist on the computer?

Run:

filename DIR pipe 'dir "C:\SAS 9.4\SAS-II Class\Raw Data\SD*" ';
data null_;
  infile DIR;
  input;
  put _infile_; 
run;

and show the results

Re: Library DBSDTM does not exist.

Kurt_Bremser — Fri, 18 Jan 2019 08:31:39 GMT

Which SAS setup are you using?

University Edition
On Demand For Academics
Server-based with SAS Studio
Server-based with SAS Enterprise Guide
Single machine, everything on your desktop, either with Enterprise Guide or Display Manager

Re: Library DBSDTM does not exist.

Patelbb — Sat, 19 Jan 2019 16:50:58 GMT

Hi,

This is the result from the submitted code. The file path I used was copied right from the file so not sure why it doesn't recognize it.

135 filename DIR pipe 'dir "C:\SAS 9.4\SAS-II Class\Raw Data\SDTM" ';
136 data null_;
137    infile DIR;
138    input;
139    put _infile_;
140 run;

NOTE: The infile DIR is:
      Unnamed Pipe Access Device,
      PROCESS=dir "C:\SAS 9.4\SAS-II Class\Raw Data\SDTM",
      RECFM=V,LRECL=32767

Volume in drive C is OS
Volume Serial Number is 1A1D-B685

Directory of C:\SAS 9.4\SAS-II Class\Raw Data
Stderr output:
File Not Found
NOTE: 5 records were read from the infile DIR.
      The minimum record length was 0.
      The maximum record length was 46.
NOTE: The data set WORK.NULL_ has 5 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.63 seconds
      cpu time            0.06 seconds

Re: Library DBSDTM does not exist.

Kurt_Bremser — Sat, 19 Jan 2019 20:11:27 GMT

Directory SDTM does not exist in that location.

@Patelbb wrote:

Hi,

This is the result from the submitted code. The file path I used was copied right from the file so not sure why it doesn't recognize it.

135 filename DIR pipe 'dir "C:\SAS 9.4\SAS-II Class\Raw Data\SDTM" ';
136 data null_;
137    infile DIR;
138    input;
139    put _infile_;
140 run;

NOTE: The infile DIR is:
      Unnamed Pipe Access Device,
      PROCESS=dir "C:\SAS 9.4\SAS-II Class\Raw Data\SDTM",
      RECFM=V,LRECL=32767

Volume in drive C is OS
Volume Serial Number is 1A1D-B685

Directory of C:\SAS 9.4\SAS-II Class\Raw Data
Stderr output:
File Not Found
NOTE: 5 records were read from the infile DIR.
      The minimum record length was 0.
      The maximum record length was 46.
NOTE: The data set WORK.NULL_ has 5 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.63 seconds
      cpu time            0.06 seconds