Extracting Characters

[Tihannah]

Trying to extract only characters from a column, i.e.

JIM325612

SARAH651291

Each has 6 digits behind them but the amount of characters vary. How do I just pull the characters using 'SUBSTR' or something similar?

[novinosrin · Accepted solution]

want=compress(your_variable,,'d');

[novinosrin]

data h;
input var $15.;
datalines;
JIM325612
SARAH651291
;
data want;
set h;
want=compress(var,,'d');
run;

[Tihannah]

Thank you so much! Worked perfect!