Split a word from one to two columns

[lca]

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

[art297]

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;

[Vish33]

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