topic Re: How to import multiple delimiters file ? in SAS Programming

How to import multiple delimiters file ?

whymath — Tue, 21 May 2019 07:58:34 GMT

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?

Re: How to import multiple delimiters file ?

Jagadishkatam — Tue, 21 May 2019 08:34:28 GMT

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;

Re: How to import multiple delimiters file ?

Kurt_Bremser — Tue, 21 May 2019 11:51:56 GMT

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.

Re: How to import multiple delimiters file ?

Ksharp — Tue, 21 May 2019 12:44:44 GMT

proc import

dlm = '3B09'x

Re: How to import multiple delimiters file ?

Tom — Tue, 21 May 2019 12:54:37 GMT

@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.

Re: How to import multiple delimiters file ?

whymath — Wed, 22 May 2019 02:26:33 GMT

Thanks, that works.

Re: How to import multiple delimiters file ?

whymath — Wed, 22 May 2019 02:27:55 GMT

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

Re: How to import multiple delimiters file ?

whymath — Wed, 22 May 2019 02:30:05 GMT

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