Help using Base SAS procedures

string operation

Reply
Regular Contributor
Posts: 222

string operation

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;

Valued Guide
Posts: 765

Re: string operation

Posted in reply to Mike_Davis

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;

Ask a Question
Discussion stats
  • 1 reply
  • 146 views
  • 0 likes
  • 2 in conversation