strippin characters

[Solly7]

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

[PeterClemmensen]

Is it always the last part of the string?

[Solly7]

That is Correct!

[PeterClemmensen · Accepted solution]

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;

[Solly7]

Bro, it works perfectly fine.. thank you

[PeterClemmensen]

Anytime 🙂