- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 06-28-2018 08:26 PM
(1202 views)
Hello,
I'm trying to remove 'B4071234' from subjid variable -B4071234 1234 11111111
data final
set test;
substr(strip(CONT_CD),1,8)='';
run;
I'm getting error.
Thanks
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data want;
var='B4071234 1234 11111111';
want=substr(var,anyspace(var));
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Thanks for the quick response.
What do you mean anyspace ? number of character to remove ?
want=substr(var,anyspace(var));
Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
basically that logic finds a the first blank space which is the delimiter and extracts all chars after the delimiter space, consequently ignoring the chars you mentioned above
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
When SUBSTR appears to the left of the equal sign, the first parameter must be a variable name (not an expression such as using STRIP). You could try something along the lines of:
CONT_CD = substr(CONT_CD, 10);