topic Re: string starts with number or letter in New SAS User

string starts with number or letter

mlogan — Thu, 27 Feb 2020 23:45:58 GMT

I need to know the observations where var1 starts with a number and var2 starts with a letter. Can someone please help me with the code.

Here is my sample data.

Thanks,

DATA have;
INPUT var1 $10. var2 $10.;
DATALINES;
A153C254	BBF
3 Cuort		5nng
4hhg		r4ee5
B124 		CC8	
0564		1DD	
15D48 		FF	 
na 3N2	
w853	    55K
run;

Re: string starts with number or letter

ballardw — Fri, 28 Feb 2020 00:07:37 GMT

What do you expect the result to look like when digit or letter is found in the first position?

The functions ANYDIGIT, ANYLOWER or ANYUPPER may help depending on your desired output.

If ANYDIGIT(var1) = 1 then var1 starts with a digit for example.

Re: string starts with number or letter

mlogan — Fri, 28 Feb 2020 03:29:41 GMT

Thanks, it worked for me.

Re: string starts with number or letter

PeterClemmensen — Fri, 28 Feb 2020 08:07:24 GMT

Alternatively..

DATA have;
INPUT var1 $ 1-8 var2 $ 10-14;
DATALINES;
A153C254 BBF  
3 Cuort  5nng 
4hhg     r4ee5
B124     CC8  
0564     1DD  
15D48    FF   
na 3N2        
w853     55K  
;

data want;
    set have;
    if prxmatch('/^\d.*/', var1) & 
       prxmatch('/^[a-zA-Z].*/', var2);
run;