HI, It could be the easiest solution i believe ( Tried and tested) . Please let me know if it helps. Thanks!! data x; input str $ 1-40; y=index(str,'%'); val = substr(str,y-2); datalines; Charity 90% Save the Whales 10% Relief Assist. Inc. 20% Cuida Ltd. 80% ; proc print; run;
... View more