Hello all,
I have a SAS data set has a variable names 'string' its value looks like: "a1|a2|a3|a4", "a1|a2", "a1", "a1|a2|a3" (some obs has less '|' and some has more "|") ;
I want to create new variables x1=a1,x2=a2,x3=a3........ but it does not work,
please help.
Thanks!
Here is my code:
data have;
string= "a1|a2|a3|a4"; output;
string= "a1|a2"; output;
string= "a1|a2|a3"; output;
run;
data want;
length x1 x2 x3 x4 x5 $200 ;
set have;
do i=1 to countw(string,"|")
;
/*call symput('x'||left(_i_), scan(string,i,"|"));*/
x%trim(%left(i))=scan(string,i,"|");
end;
run;
... View more
