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

How to import text file contains multiple delimiters

Divya_Joseph — Tue, 09 Apr 2019 06:37:46 GMT

Hi all,

I am trying to import text file which contains delimiters such as tab and _ . Underscore is working. But Tab is not working.

proc import datafile='C:\Users\bijo\Documents\SAS Practice\ImportText2.txt'
out=p1
dbms=dlm replace;
delimiter='_ '09'x ' ;
Getnames=no;
proc print;
run;

Please help

Re: How to import text file contains multiple delimiters

Kurt_Bremser — Tue, 09 Apr 2019 06:56:18 GMT

Translate the tabs to underlines first, and use the underlines as standard delimiter:

data test;
infile datalines dlm='_' dsd;
input @;
_infile_ = translate(_infile_,'_','09'x);
input city :$20. state : $20. val1 val2;
datalines;
Melbourne_Victoria	240	600	
Sydney_nsw_120_430 
Adelaide_SA_400_500 
;
run;

The first input is just there to fill the buffer (_infile_), and holds the line (@). The second input reads the data.

proc import is not able to handle such a situation.

Re: How to import text file contains multiple delimiters

vThanu — Tue, 09 Apr 2019 08:36:29 GMT

Using data step first record is not reading properly......

Re: How to import text file contains multiple delimiters

Kurt_Bremser — Tue, 09 Apr 2019 08:41:45 GMT

Use firstobs=2 in the infile statement to skip the header.

Otherwise, my code (copy/pasted from here directly to the EG Enhanced Editor and submitted):

data test;
infile datalines dlm='_' dsd;
input @;
_infile_ = translate(_infile_,'_','09'x);
input city :$20. state : $20. val1 val2;
datalines;
Melbourne_Victoria	240	600	
Sydney_nsw_120_430 
Adelaide_SA_400_500 
;
run;

proc print data=test noobs;
run;

produces this result:

city         state       val1    val2

Melbourne    Victoria     240     600
Sydney       nsw          120     430
Adelaide     SA           400     500

If you have any trouble, post log ({i} button!) and results.

Re: How to import text file contains multiple delimiters

vThanu — Tue, 09 Apr 2019 13:37:52 GMT

Thanks for your reply.....
While iam trying to execute the same code in SAS 9.4 not reading properly

Re: How to import text file contains multiple delimiters

Ksharp — Tue, 09 Apr 2019 13:45:08 GMT

Find _ 's hex value .and

delimiter='5F09'x ;

Re: How to import text file contains multiple delimiters

Divya_Joseph — Wed, 10 Apr 2019 10:49:02 GMT

Thank you