topic Re: How to remove strings which contain numbers? in SAS Programming

How to remove strings which contain numbers?

Shradha1 — Tue, 16 Mar 2021 10:12:37 GMT

I have a list of strings which contain both alphabets and numericals.
I want to keep only those strings which contain only alphabets or a combination of alphabets and numerics. I want to remove strings which contain only numericals. How do I achieve this?

Re: How to remove strings which contain numbers?

PeterClemmensen — Tue, 16 Mar 2021 10:19:17 GMT

Use the Anyalpha Function like this

data have;
input s $;
datalines;
12345 
abc12
12abc
23456
;

data want;
   set have;
   if anyalpha(s);
run;

Re: How to remove strings which contain numbers?

BrahmanandaRao — Tue, 16 Mar 2021 10:19:38 GMT

Provide data

Re: How to remove strings which contain numbers?

Kurt_Bremser — Tue, 16 Mar 2021 10:21:47 GMT

Use the ANYDIGIT function:

data have;
input string $10.;
datalines;
abc
defg
abc12de
;

data want;
set have;
where anydigit(string) = 0;
run;

Re: How to remove strings which contain numbers?

rudfaden — Tue, 16 Mar 2021 10:28:27 GMT

Try regex

data have;
input string $10.;
datalines;
asd123ffgg
sdffggghhj
34fggghhhh
dfvd
dvrfgbbfe1
;
run;


data want;
set have;
	pattern="s/\d+/$1/";
	patternid=prxparse(pattern);

	if not prxmatch(patternid,string) then do;
		output;
	end;
run;