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

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

amsa1996 — Tue, 28 Apr 2020 10:22:53 GMT

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?

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

PeterClemmensen — Tue, 28 Apr 2020 10:31:38 GMT

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;

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

Kurt_Bremser — Tue, 28 Apr 2020 12:18:32 GMT

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;

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

amsa1996 — Tue, 28 Apr 2020 12:48:42 GMT

Sorry about that...

Thank you for your help! It worked.