You can try @Reeza's suggestion by using 's' modifier in the SCAN(),
data want;
text="abcdef"||'09'x||"defe";
do i=1 to 2;
_s1=scan(text,i,'','s');
output;
end;
run;
If this does not work out, try another suggestion also provided by @Reeza, to print out all chars in HEX, then you will be able to pinpoint your delimiter, of course, only try it on serveral obs to figure it out.
data want;
text="abcdef"||'09'x||"defe";
len=length(text);
do i=1 to len;
char=char(text,i);
hex=put(char,$hex2.);
output;
end;
run;
As you can see from above example, after running, 7th(i=7) is a tab, hex=09, so next is easy:
data want;
text="abcdef"||'09'x||"defe";
do i=1 to 2;
_s1=scan(text,i,'09'x);
output;
end;
run;
... View more
