string operation

Mike_Davis — Fri, 06 Jul 2012 21:07:26 GMT

Hello everyone,

I have two questions:

Thanks!

How to use string function to find the first none 'x' letter?

data have;

value='xxasdxfg';output;

value='xxxxqwerxxt';output;

run;

data need;

value

asdxfg

qwerxxt

how to use string function keep the last N digit?

data have;

x='123456789';

run;

data want;

set have;

x2=substr(x,-4); /*I need x2=6789,the last four digits of x*/

run;

Re: string operation

MikeZdeb — Fri, 06 Jul 2012 21:20:07 GMT

hi ...

data have;

value='xxasdxfg';output;

value='xxxxqwerxxt';output;

run;

data want;

set have;

new = substr(value,verify(value,'x'));

run;

data have;

x = '123456789';

run;

data want;

set have;

x2 = substr(x,length(x)-3);

run;