How to remove strings which contain numbers?

[Shradha1]

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?

[PeterClemmensen · Accepted solution]

Use the Anyalpha Function like this

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

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

[BrahmanandaRao]

Provide data

[Kurt_Bremser]

Use the ANYDIGIT function:

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

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

[rudfaden]

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;