topic Re: how to include the delimiter in the output value when scan function used in SAS Programming

how to include the delimiter in the output value when scan function used

knveraraju91 — Wed, 31 Jul 2019 19:42:48 GMT



data one;
input a $10.;
datalines;
aaaa+bbbbb
cccc+ddddd
;
data two;
set one;
b=scan(a,1,'+');
c=scan(a,2,'+');
run;

Dear,

For the above data step, i need to output for b and c vaiables as below. The delimiter should also be included in first word. Please suggest.

b c

aaaa+ bbbbb

cccc+ ddddd

data_null__ — Wed, 31 Jul 2019 19:45:07 GMT

b=cats(scan(a,1,'+'),'+');

r_behata — Wed, 31 Jul 2019 20:24:27 GMT

data two;
set one;
pos=find(a,'+');
b=substrn(a,1,pos);
c=substrn(a,pos+1);
drop pos;
run;