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

?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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