DATA Step, Macro, Functions and more

substring

Reply
New Contributor de
New Contributor
Posts: 2

substring

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

PROC Star
Posts: 1,817

Re: substring

data want;
var='B4071234 1234 11111111';
want=substr(var,anyspace(var));
run;
New Contributor de
New Contributor
Posts: 2

Re: substring

Posted in reply to novinosrin

Hi,

 

Thanks for the quick response. 

 

What do you mean anyspace ?  number of character to remove ?

want=substr(var,anyspace(var));

 Thanks again.

PROC Star
Posts: 1,817

Re: substring

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

Super User
Posts: 6,781

Re: substring

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);

Ask a Question
Discussion stats
  • 4 replies
  • 70 views
  • 0 likes
  • 3 in conversation