data have;
input info $ 1 - 50;
cards;
101 pencils 37
102 parker pens 61
103 apple ipod shuffle & nano 08
104 dell studio laptop 03
;
data want;
set have;
term1=scan(info,1,' ');
term2=prxchange('s/^\d+\s+|\d+$//',-1,strip(info));
term3=scan(info,-1,' ');
run;
... View more
