topic Re: Variable Account_Name contain both character and numeric in SAS Programming

Variable Account_Name contain both character and numeric

arvekumar — Wed, 15 Feb 2017 17:25:22 GMT

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

CDI

ABCD

AZD

AccCode

347

7890

112

Any one help me

i need ans for this ???

Thanks in advance

Astounding — Wed, 15 Feb 2017 18:16:40 GMT

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

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

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

arvekumar — Thu, 16 Feb 2017 03:29:36 GMT

Thanks it worked