alphabet and numeric using like operator

[BrahmanandaRao]

data ds;
input text $;
datalines;
abcll12
slff37
uyxiiz3
123
;
run;

proc sql;
select * from ds
where text like '%[a-z]%'  as alphabet and like '%[0-9]%' as numeric ;
quit;

I want to get alphabet and numeric from this data instead of compress function  using like operator

[Kurt_Bremser]

Your code does not make any sense. Please show us the expected result from your example data.

[andreas_lds]

Please show the expected result, it is not clear what you want. And please explain why you don't want to use compress.

[BrahmanandaRao]

Alphabet	Numeric
abcll	12
slff	37
uyxiiz	3
123	123

[Kurt_Bremser]

So you want to create two new variables, one containing only numeric characters, the other the rest?

The proper tool for this is the COMPRESS function, as you already mentioned, so use it (Maxim 14).

The WHERE clause in SQL is for filtering observations, not for creating variables.

[Kurt_Bremser]

PS why do you have the digits "123" in alphabet in the last observation? There, the variable should be empty.

[andreas_lds]

And what do you expect if the original value is "a1b2c3"? Or is it 100% sure that you have one block of non-digits and another of only digits?

[Kurt_Bremser]

Also see Maxim 1: Read the Documentation:

LIKE Operator 

The LIKE operator does not support regular expressions.