🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 02-15-2017 12:25 PM
(1022 views)
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
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Accld = compress(account_name, , 'd');
AccCode = compress(account_name, , 'kd');
In the third parameter of COMPRESS: d=digits, k=keep
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Accld = compress(account_name, , 'd');
AccCode = compress(account_name, , 'kd');
In the third parameter of COMPRESS: d=digits, k=keep
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks it worked