topic Split a word from one to two columns in SAS Programming

Split a word from one to two columns

lca — Sat, 04 Feb 2012 15:19:13 GMT

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

Split a word from one to two columns

art297 — Sat, 04 Feb 2012 15:26:23 GMT

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;

Split a word from one to two columns

Vish33 — Thu, 09 Feb 2012 19:39:28 GMT

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