read a file delimited by string

[Aexor]

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'

[FreelanceReinh · Accepted solution]

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;

[Aexor]

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