topic Re: read a file delimited by string in SAS Programming

read a file delimited by string

Aexor — Thu, 29 Jul 2021 11:01:20 GMT

I want to read values from mytext file

mytext

RamabcSamabcKaleabc

How to read data this type of file. Please advise.

Also please let me know if i can specify string in dlm option

for e.g dlm='abc'

Re: read a file delimited by string

FreelanceReinh — Thu, 29 Jul 2021 11:23:27 GMT

Hello @Aexor,

You can specify strings as delimiters in the DLMSTR= option of the INFILE statement:

/* Create test file for demonstration */

filename myfile temp; 

data _null_;
file myfile;
put 'RamabcSamabcKaleabc';
run;

/* Read the test file */

data want;
infile myfile dlmstr='abc';
input (var1-var3)($);
run;

Re: read a file delimited by string

Aexor — Thu, 29 Jul 2021 11:26:38 GMT

Awesome! I didn't new there is such thing like dlmstr
thanks much 🙂