split up and create copies

hdg — Wed, 17 May 2017 15:24:25 GMT

Hello,

I have a quick question

I have a table which looks like below

SEQ MODE TYPE assign_value

1 m x a, axau

1 m y a,axau

1 m z m, x, n

.....

I would like to get the following such that assignvalue which is separated by commas creates a duplicate row for each assign_value value which is separated by commas

SEQ MODE TYPE assign_value

1 m x a

1 m x axau

1 m y a

1 m y axau

1 m z m

1 m z x

1 m z n

.....

many thanks for your help

Re: split up and create copies

RW9 — Wed, 17 May 2017 15:33:44 GMT

Hi,

data want (drop=i old);
  set have (rename=(assign_value=old));
  length assign_value $100;
  do i=1 to countw(old,",");
    assign_value=scan(old,i,",");
    output;
  end;
run;

topic split up and create copies in SAS Programming

split up and create copies

Re: split up and create copies