Splitting of column values based on number of values.

[samirt]

Hi,

I have a dataset in which a column consist more than on value. I would like to split the column as per the number of values(As shown in the expected output).

A                     B

Agriculture     417,859
Power            0059
Real Estate    0038,622
Roads            3243
Telecom         0041

Expected Output

A                     B

Agriculture      417

Agriculture      859

Power            0059

Real Estate    0038

Real Estate    622

Roads            3243

Telecom         0041

Thanks in Advance

[Kurt_Bremser · Accepted solution]

data want;
set have (rename=(B=oldB));
value_count = countw(oldB,',');
do i = 1 to value_count;
  B = scan(oldB,i,',');
  output;
end;
keep A B;
run;