Column with comma

[soz]

Hi,

I have a column in my sas table which includes several numbers separated by a comma (for example: 123,124,125,126).

The amount of the numbers in the column is not fixed (i can't know it's length).

I need to seperate it to lines/

for example:

This is my sas table:

customer    content

x                 123,124,125

y                 502,487,503,478,65

This is the sas table i want to create:

customer     content

x                  123

x                  124

x                  125

y                  502

y                  487

y                  503

y                  478

y                    65

Thank you all

[RW9]

Hi,

Combine a do loop with a scan and output:

data have;
  length content $200;
  customer="x"; content="123,124,125"; output;
  customer="y"; content="502,487,503,478,65"; output;
run;

data want;
  set have;
  do i=1 to countc(content,",")+1;
    new_record=scan(content,i,",");
    output;
  end;
run;