How to filter out/remove text in a column containing text and numeric values

[amsa1996]

Hi!

I want to filter out/remove the text "declaration" in my table, so that i only have the numeric value.

Can someone help me with this?

[PeterClemmensen]

Like this?

data have;
input case_concept_name $ 1-20;
datalines;
declaration 14447
declaration 14750
declaration 76001
declaration 14559
declaration 85327
;

data want;
    set have;
    newvar = input(compress(case_concept_name, , 'kd'), 8.);
run;

[Kurt_Bremser · Accepted solution]

Please DO NOT post data as pictures. I'm not hired as your typist.

This will do it:

data want;
set have;
newvar = input(scan(case_concept_name,2),best.);
run;

[amsa1996]

Sorry about that...

Thank you for your help! It worked.