You probably don't need to split them up even to do that see below. However that being said it would really be a good idea to split them up, but in long form rather than wide:
data want (keep=wrd);
set have;
length wrd $20;
do i=1 to countw(original,",");
wrd=scan(original,i,",");
output;
end;
run;
That is a far simpler and easier to work with data structure.
To show how to co it without changing:
proc sql;
create table WANT as
select sum(count(ORIGINAL,"TT")) as WANT
from HAVE;
quit;
... View more
