How to import multiple delimiters file ?

[whymath]

How to import a .txt file which has both semicolon and tab as delimiters ?

I have tried dlm = "; '09'x" but happened to an error. Can somebody give me any hints?

[Jagadishkatam]

Hope this will help

use the dlmstr=';'

Specifies either a character string or the value of a character variable as the delimiter.

data a; 
   infile 'C:\sas\example1.csv' dlm='09'x dlmstr=';' dsd truncover; 
   input fname $ lname $ age; 
run; 

[whymath]

The dlmstr=';' may cover the dlm='09'x

[Kurt_Bremser]

Please post a few lines of your .txt file into a window opened with the {i} button, so we have something to test code against.

[whymath]

I will do it next time, thanks for your kindly remind.

[Ksharp]

proc import  

 dlm = '3B09'x

[whymath]

Thanks, that works.

[Tom · Accepted solution]

---

@whymath wrote:

How to import a .txt file which has both semicolon and tab as delimiters ?

I have tried dlm = "; '09'x" but happened to an error. Can somebody give me any hints?

---

You can either find the hexcode for semi-colon (3B) and include it in your hex literal along with the 09 for the tab character.

Or you can use a variable to hold the list of delimiters.

dlm=';' || '09'x ;
infile .... dlm=dlm ... ;

Note that if you use a variable to hold the list of delimiter characters then you can actually change it during the data step.