Column with comma

soz — Mon, 02 Nov 2015 14:13:03 GMT

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

Re: Column with comma

RW9 — Mon, 02 Nov 2015 14:31:58 GMT

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;

topic Column with comma in SAS Enterprise Guide

Column with comma

Re: Column with comma