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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.