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
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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.