Hi!
I have a table with a column where some of the values (characters) are separated with a semicolon.
I want to split the values into two columns.
From:
Column 1 |
---|
1_LeftText;1_RightText |
2_Text |
3_LeftText;3_RightText |
To:
Column 1 | Column 2 |
---|---|
1_LeftText | 1_RightText |
2_Text | |
3_LeftText | 3_RightText |
Probably easy, but.... 🙂
lca
data have;
informat column $50.;
input column &;
datalines4;
1_LeftText;1_RightText
2_Text
3_LeftText;3_RightText
;;;;
data want;
set have;
format column1 column2 $25.;
column1=scan(column,1,";");
column2=scan(column,2,";");
run;
Consider Art's code and
drop the variable 'column' from the want data set if you want only two variables column1 and column2.
data want(drop=column);
set have;
format column1 column2 $25.;
column1=scan(column,1,";");
column2=scan(column,2,";");
run;
proc print data=want;
run;
Regards,
Vish
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.