topic split numeric and character in 1 column to 2 colums in SAS Enterprise Guide

split numeric and character in 1 column to 2 colums

Bronnewasser — Thu, 22 Sep 2016 08:34:58 GMT

One column contains numeric and character. I want to split this to two columns.

1234567 - Romana

The number is a registernumber and the name is the name of the registergood.

I want two columns.

Reg.nr. and name

1234567 Romana

Re: split numeric and character in 1 column to 2 colums

Kurt_Bremser — Thu, 22 Sep 2016 08:50:18 GMT

To split the string, use the scan() function, and then you can further process the parts:

data want;
set have;
numvar = input(scan(oldvar,1,'-'),best.);
length namevar $20; * use sufficient length here;
namevar = strip(scan(oldvar,2,'-')); * strip removes blanks;
run;