Variable Account_Name contain both character and numeric

[arvekumar]

Hi, 

I am studying Base SAS , i have doubt on topic 

for example in one variable i have both numeric and character 

I need to separate numeric as one new variable and characters as one new variable

RAW DATA

Account_Name

AQI2

A347B

89CDI

7890

ABCD

A1Z1D2

I need output as

AccId

AQI

AB

CDI

.

ABCD 

AZD

AccCode

2

347

89

7890

.

112

Any one help me 

i need ans for this ???

Thanks in advance

[Astounding · Accepted solution]

Accld = compress(account_name, , 'd');

AccCode = compress(account_name, , 'kd');

In the third parameter of COMPRESS: d=digits, k=keep

[arvekumar]

Thanks it worked