string operation

[Mike_Davis]

Hello everyone,

I have two questions:

Thanks!

1.

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

2.

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;

[MikeZdeb]

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;