topic substring in SAS Programming

substring

de — Fri, 29 Jun 2018 00:26:00 GMT

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

Re: substring

novinosrin — Fri, 29 Jun 2018 00:32:03 GMT

data want;
var='B4071234 1234 11111111';
want=substr(var,anyspace(var));
run;

Re: substring

Astounding — Fri, 29 Jun 2018 00:33:23 GMT

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

Re: substring

de — Fri, 29 Jun 2018 01:25:52 GMT

Hi,

Thanks for the quick response.

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

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

Thanks again.

Re: substring

novinosrin — Fri, 29 Jun 2018 02:43:19 GMT

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