## Splitting of column values based on number of values.

Solved
Occasional Contributor
Posts: 15

# Splitting of column values based on number of values.

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).

B

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

Expected Output

B

Agriculture      417

Agriculture      859

Power            0059

Real Estate    0038

Real Estate    622

Telecom         0041

Accepted Solutions
Solution
‎01-18-2016 04:28 AM
Super User
Posts: 10,280

## Re: Splitting of column values based on number of values.

``````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;``````
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

All Replies
Solution
‎01-18-2016 04:28 AM
Super User
Posts: 10,280

## Re: Splitting of column values based on number of values.

``````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;``````
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
🔒 This topic is solved and locked.