proc import with a .txt file with a | delimiter

[n6]

I'm using proc import for a .txt file and the delimiter in it is |.

My DBMS line had been DBMS = TAB REPLACE; but that does not work with the | delimiter.

I've also tried

DBMS = DLM  = '|' REPLACE;

DBMS = DLM REPLACE;

DBMS = '|' REPLACE;

None of them work.  Anyone with any idea what would work?  Any info is appreciated.

[Reeza · Accepted solution]

proc import datafile="path to your txt file" out=mydata dbms=dlm replace;
   delimiter="|";
   getnames=yes;
run;

---

@n6 wrote:

I'm using proc import for a .txt file and the delimiter in it is |.

My DBMS line had been DBMS = TAB REPLACE; but that does not work with the | delimiter.

I've also tried

DBMS = DLM  = '|' REPLACE;

DBMS = DLM REPLACE;

DBMS = '|' REPLACE;

None of them work.  Anyone with any idea what would work?  Any info is appreciated.

---

[n6]

It works.  Beautiful.  Thank you.

[ballardw]

---

@n6 wrote:

I'm using proc import for a .txt file and the delimiter in it is |.

My DBMS line had been DBMS = TAB REPLACE; but that does not work with the | delimiter.

I've also tried

DBMS = DLM  = '|' REPLACE;

DBMS = DLM REPLACE;

DBMS = '|' REPLACE;

None of them work.  Anyone with any idea what would work?  Any info is appreciated.

---

What did you log show? Expect several different errors.

The example from the documentation gives you pretty clear example:

proc import datafile=<your filename goes here>
        dbms=dlm
        out=<your data set name goes here>
        replace;

     delimiter='|';
     getnames=yes;
run;