split up and create copies

[hdg]

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

[RW9 · Accepted solution]

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;