split numeric and character in 1 column to 2 colums

[Bronnewasser]

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

[Kurt_Bremser]

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;