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
Accld = compress(account_name, , 'd');
AccCode = compress(account_name, , 'kd');
In the third parameter of COMPRESS: d=digits, k=keep
Accld = compress(account_name, , 'd');
AccCode = compress(account_name, , 'kd');
In the third parameter of COMPRESS: d=digits, k=keep
Thanks it worked
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.