Splitting of column values based on number of values.

samirt — Mon, 18 Jan 2016 06:46:24 GMT

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

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

Kurt_Bremser — Mon, 18 Jan 2016 07:09:26 GMT

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;

topic Splitting of column values based on number of values. in SAS Programming

Splitting of column values based on number of values.

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