Hi All, Here is the original dataset: data m01; a="CGA AMZN.COM CA";output; a="CHA AMZN.COM HK";output; run; Output dataset like: Word CGA AMZN.COM CA CHA AMZN.COM HK Any idea? Here is mine: data m02; set m01; an=translate(a,"@"," "); run; data m02_1; set m02; an=tranwrd(an,"@@","@"); run; %macro REEE; %do i=1 %to 10; data m02_1; set m02_1; an=tranwrd(an,"@@","@"); run; %end; %mend; %REEE; data m03; set m02_1; bn=an; No=_N_; j=0; do until(j=0); j=find(bn,"@"); i=1; Word=substr(bn,i,j-i); i+j; bn=substr(bn,i,j-i); output; end; run; In fact the original dataset contains thousands of merchants description,I want to break it down into words. What's your suggestion,please? Thanks in advance.
... View more