topic Re: strippin characters in SAS Programming

strippin characters

Solly7 — Wed, 15 Jan 2020 12:15:03 GMT

Hi, i need to remove unwanted characters from my 'description column'..please note that the length of the string is not the same on all the rows below. But i only need those last six digits which starts with 1 on an each every row.

Data Have Data Want

Description Description

magma ret3x122354565 190121 190121

buddyoli1234533 180203 180203

brasty omo1903737383 190506 190506

Re: strippin characters

PeterClemmensen — Wed, 15 Jan 2020 12:16:57 GMT

Is it always the last part of the string?

Re: strippin characters

Solly7 — Wed, 15 Jan 2020 12:18:16 GMT

That is Correct!

Re: strippin characters

PeterClemmensen — Wed, 15 Jan 2020 12:35:49 GMT

Then simply do

data have;
input description :$&200.;
datalines;
magma ret3x122354565 190121
buddyoli1234533 180203     
brasty omo1903737383 190506
;

data want;
    set have;
    newdecription=scan(description, -1);
run;

Re: strippin characters

Solly7 — Wed, 15 Jan 2020 12:58:56 GMT

Bro, it works perfectly fine.. thank you

Re: strippin characters

PeterClemmensen — Wed, 15 Jan 2020 13:03:05 GMT

Anytime 🙂