Remove the comma's from the numbers is the easiest solution.
/* Sample input data */
data have;
input text $100.;
datalines;
Business Meeting - Involved, MTNG - Meals > 5,000XYZ, XYZ & ABC > 5,000XYZ, XYZ - Meal > 5,000XYZ
;
data want;
set have;
*remove commas in numbers;
new_text=prxchange('s/(\d+),(\d+)/$1$2/', -1, text);
*count number of terms;
nterms=countc(new_text, ",");
*expand out;
do i=1 to nterms+1;
term=scan(new_text, i, ",");
output;
end;
run;
/* View the output */
proc print data=want;
run;
... View more