topic Re: find and replace part of a string but only at the start of a variable in SAS Programming https://communities.sas.com/t5/SAS-Programming/find-and-replace-part-of-a-string-but-only-at-the-start-of-a/m-p/632318#M187460 <P>I will assume that MOBILE is a character variable.</P> <PRE><CODE class=" language-sas">if mobile=:'614' then mobile='04'||substr(mobile,4);</CODE></PRE> Mon, 16 Mar 2020 03:47:58 GMT Tom 2020-03-16T03:47:58Z find and replace part of a string but only at the start of a variable https://communities.sas.com/t5/SAS-Programming/find-and-replace-part-of-a-string-but-only-at-the-start-of-a/m-p/632315#M187459 <P>I want to be able to find and replace '614' from the start of 'mobile' (not any other section of it) with 04.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Mobile</TD></TR><TR><TD>61420202</TD></TR><TR><TD>46145555</TD></TR><TR><TD>614566666</TD></TR><TR><TD>4532790</TD></TR></TBODY></TABLE> Mon, 16 Mar 2020 03:24:15 GMT https://communities.sas.com/t5/SAS-Programming/find-and-replace-part-of-a-string-but-only-at-the-start-of-a/m-p/632315#M187459 BenBrady 2020-03-16T03:24:15Z Re: find and replace part of a string but only at the start of a variable https://communities.sas.com/t5/SAS-Programming/find-and-replace-part-of-a-string-but-only-at-the-start-of-a/m-p/632318#M187460 <P>I will assume that MOBILE is a character variable.</P> <PRE><CODE class=" language-sas">if mobile=:'614' then mobile='04'||substr(mobile,4);</CODE></PRE> Mon, 16 Mar 2020 03:47:58 GMT https://communities.sas.com/t5/SAS-Programming/find-and-replace-part-of-a-string-but-only-at-the-start-of-a/m-p/632318#M187460 Tom 2020-03-16T03:47:58Z