BookmarkSubscribeRSS Feed
Patelbb
Fluorite | Level 6

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.

 

4 REPLIES 4
ChrisNZ
Tourmaline | Level 20

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

 

Patelbb
Fluorite | Level 6

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
 
Kurt_Bremser
Super User

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
 

 

Kurt_Bremser
Super User

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

?

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1579 views
  • 0 likes
  • 3 in conversation