About Shemp

Shemp · ‎09-10-2019

data have; input date &$100.; date2=prxchange('s/(UN\s)(UNK\s)(\d*)/-- --- $3/i',-1,strip(date)); cards; UN UNK 2018 UN 2018 UNK 2018 UN UNK ; In the above, the first line in the CARDS statement works, but the next 4 fail.

Shemp · ‎06-20-2019

Try this: data test; length var_date 8; length var_num 8; format var_date yymmn6.; var_date='01JUN2019'd; var_num =input(put(var_date, yymmn6.), 6.); run;

Shemp · ‎06-10-2019

Substitute this for the substring function: prxchange('s/[^\d]//', -1, sitenumber)

Shemp · ‎04-19-2019

Try this: data temp; length extracted_value $ 10; input char_str $ 1-20; extracted_value = prxchange('s/^[^X]*X(.*?)\x2C.*$/$1/',1,char_str); datalines; X20l,p5,op3 cX3z,p4,op2(1) ;

Shemp · ‎11-11-2018

For an increase in speed, try the following which uses lazy repetition factors (i.e. \s*?) data test; length var1 $ 100 var2 $ 100; var1=' // / /ab c / d e f /g hij/ //kl m/ / '; var2=prxchange('s/\s*?(\/)\s*?(?!\s)/$1/', -1, var1); run;

Shemp · ‎11-11-2018

Those are capture buffers.

Shemp · ‎11-09-2018

data test; length var1 $ 20 var2 $ 20; var1='abc / def / efg'; var2=prxchange('s/([^\s]*)\s*(\/)\s*([^\s]*)/$1$2$3/', -1, var1); run;

Shemp · ‎09-13-2018

Like this... data have; input date &$100.; length new $ 100; /*new = prxchange('s/\bUNK\b/---/', -1, date);*/ /*new = prxchange('s/\bUN\b/--/', -1, new);*/ new = prxchange('s/\bUN\b/--/', -1, prxchange('s/\bUNK\b/---/', -1, date)); cards; UN UNK 2018 ;

Shemp · ‎09-13-2018

I don't believe it is possible to do in a single line unless you embed a prxchange function as the 3rd argument to a prxchange function.

Shemp · ‎09-13-2018

data have; input date &$100.; length new $ 100; new = prxchange('s/\bUNK\b/---/', -1, date); new = prxchange('s/\bUN\b/--/', -1, new); cards; UN UNK 2018 ;

Online Status	Offline
Date Last Visited	‎10-03-2019 03:46 PM

Re: prxchange to replace two or more strings

Re: Converting YYYYMM date type number without changing the value in S...

Re: Remove non-numeric characters from column

Re: Extract specific pattern

Re: remove whitespace

Re: remove whitespace

Re: remove whitespace

Re: prxchange to replace two or more strings

Re: prxchange to replace two or more strings

Re: prxchange to replace two or more strings

Re: Extract specific pattern

Re: Extract specific pattern

Re: How to use a variable of a dataset as perl-regular-expression in P...

Re: Remove non-numeric characters from column

Re: prxchange to replace two or more strings

Re: prxchange to replace two or more strings

Re: Converting YYYYMM date type number without changing the value in S...

Re: Remove non-numeric characters from column

Re: Extract specific pattern

Re: remove whitespace

Re: remove whitespace

Re: remove whitespace

Re: prxchange to replace two or more strings

Re: prxchange to replace two or more strings

Re: prxchange to replace two or more strings