topic Urgent: Extract the characters before the first occurrence of ' ' or '-' in SAS Programming

Urgent: Extract the characters before the first occurrence of ' ' or '-'

tosasvj — Tue, 20 Oct 2020 23:38:33 GMT

Need to extract the characters before the first occurrence of ' ' or '-'

For example:

'ROM A STAR' output: 'ROM'

'ROMA STAR-RAN' output:'ROMA'

'VNAM-RAN STR' output: 'VNAM'

'K-NIT RAN-STA' output: 'K'

Thanks in advance!

Re: Urgent: Extract the characters before the first occurrence of ' ' or '-'

novinosrin — Wed, 21 Oct 2020 00:25:48 GMT


data have;
input var $quote20.;
cards;
'ROM A STAR' 
'ROMA STAR-RAN' 
'VNAM-RAN STR' 
'K-NIT RAN-STA' 
;
data Need;
 set have;
 length need $20;
 need=scan(var,1,' -');
run;
/*or*/
data Need;
 set have;
 length need $20;
 need=prxchange('s/^([a-z]+)[-\s].*/$1/i', -1, var);
run;
/*or even NOTALPHA*/
data Need;
 set have;
 length need $20;
 need=substr(var,1,notalpha(var)-1);
run;

Re: Urgent: Extract the characters before the first occurrence of ' ' or '-'

tosasvj — Wed, 21 Oct 2020 03:30:34 GMT

thank you!!