Desktop productivity for business analysts and programmers

Column with comma

Reply
Occasional Learner soz
Occasional Learner
Posts: 1

Column with comma

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

Super User
Super User
Posts: 7,704

Re: Column with comma

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;
Ask a Question
Discussion stats
  • 1 reply
  • 216 views
  • 1 like
  • 2 in conversation