@SASComm1 wrote: Much appreciated if one can show how to split the values into a single column in multiple rows. See below @Ksharp's sample script repurposed for a single value in multiple rows. data have; text='xx,ee,tt '; output; text='jj,ii,ii,kk'; output; run; data want; set have; do i=1 to countw(text,','); text2=scan(text,i,','); output; end; drop i; run; ... View more