Hi all,  I would like to concatenate multiple subject IDs that looks like this:   S002001~S002002, S002006~S002012, S002014~S002016     so basically, I would like to connect the subjid's that are continuous with "~" and use "," for those that is not continuous..   here's the data: data a; input subjid $8.; cards; S002001 S002002 S002006 S002007 S002008 S002009 S002010 S002011 S002012 S002014 S002015 S002016 ; run;     Thanks in advance for your help! ... View more