topic Re: concatenate multiple variables in SAS Programming

concatenate multiple variables

ykcgod — Fri, 18 Dec 2020 09:24:27 GMT

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!

Re: concatenate multiple variables

PeterClemmensen — Fri, 18 Dec 2020 09:31:28 GMT

Are all your values prefixed by "S"?

Re: concatenate multiple variables

andreas_lds — Fri, 18 Dec 2020 10:37:16 GMT

Do you want that list in saved in a dataset-variable? Can you describe what the next steps are?

Re: concatenate multiple variables

s_lassen — Fri, 18 Dec 2020 11:56:18 GMT

I think the easiest way is to start with creating a group variable:

Data grouped;
  set a;
  _number=input(substr(subjid,2),6.);
  if dif(_number) ne 1 then
    group+1;
  drop _number;
run;

Then you can use CATX to create the string:

Data want;
  set grouped end=done;
  by group;
  length Sequences $200;
  retain Sequences;
  if first.group then 
    call catx(', ',Sequences,subjid);
  else if last.group then 
    call catx('~',Sequences,subjid);
  if done;
  keep Sequences;
run;

Re: concatenate multiple variables

ykcgod — Wed, 23 Dec 2020 02:30:05 GMT

Yess! This will do. Thanks so much for your help!