topic SUBSTR function Not working! Please help me to solve the following: in SAS Programming

topic SUBSTR function Not working! Please help me to solve the following: in SAS Programming https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93650#M19747 <HTML><HEAD></HEAD><BODY><P>   1. I need to delete 10 digits from right including @ sign on email account and leave only login name for Account ID column (i.e. mjohn)</P><P>    2. You may also notice – if the names are repeated, email account is attached in parenthesis with their names. I will also need to remove the email account including      the parenthesis from Full Name column if the names have their email account attached (i.e. Tom Lee (<A href="mailto:tlee2@gmail.com">tlee2@gmail.com</A>) = Tom Lee)</P><P></P><P>Thanks,</P><P>Roger</P><P></P><P><SPAN style="text-decoration: underline;">Input data:</SPAN></P><P>Full_Name Account_ID</P><P>------------ --------------</P><P>Mary Johnson  <A href="mailto:mjohn@gmail.com">mjohn@gmail.com</A></P><P><SPAN>Mary Jonson (</SPAN><A class="jive-link-email-small" href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A><SPAN>) </SPAN><A href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A> </P><P>Robin King <A href="mailto:rking@gmail.com">rking@gmail.com</A> </P><P>Tom Lee <A href="mailto:tlee@gmail.com">tlee@gmail.com</A></P><P><SPAN>Tom Lee (</SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A><SPAN>) </SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A></P><P></P><P><SPAN style="text-decoration: underline;">Need the following output:</SPAN></P><P>Full_Name Account_ID</P><P>------------ --------------</P><P>Mary Johnson  mjohn</P><P>Mary Jonson mjohn2</P><P>Robin King rking</P><P>Tom Lee tlee</P><P>Tom Lee tlee2</P></BODY></HTML> Fri, 12 Oct 2012 21:38:45 GMT Roger 2012-10-12T21:38:45Z SUBSTR function Not working! Please help me to solve the following: https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93650#M19747 <HTML><HEAD></HEAD><BODY><P>   1. I need to delete 10 digits from right including @ sign on email account and leave only login name for Account ID column (i.e. mjohn)</P><P>    2. You may also notice – if the names are repeated, email account is attached in parenthesis with their names. I will also need to remove the email account including      the parenthesis from Full Name column if the names have their email account attached (i.e. Tom Lee (<A href="mailto:tlee2@gmail.com">tlee2@gmail.com</A>) = Tom Lee)</P><P></P><P>Thanks,</P><P>Roger</P><P></P><P><SPAN style="text-decoration: underline;">Input data:</SPAN></P><P>Full_Name Account_ID</P><P>------------ --------------</P><P>Mary Johnson  <A href="mailto:mjohn@gmail.com">mjohn@gmail.com</A></P><P><SPAN>Mary Jonson (</SPAN><A class="jive-link-email-small" href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A><SPAN>) </SPAN><A href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A> </P><P>Robin King <A href="mailto:rking@gmail.com">rking@gmail.com</A> </P><P>Tom Lee <A href="mailto:tlee@gmail.com">tlee@gmail.com</A></P><P><SPAN>Tom Lee (</SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A><SPAN>) </SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A></P><P></P><P><SPAN style="text-decoration: underline;">Need the following output:</SPAN></P><P>Full_Name Account_ID</P><P>------------ --------------</P><P>Mary Johnson  mjohn</P><P>Mary Jonson mjohn2</P><P>Robin King rking</P><P>Tom Lee tlee</P><P>Tom Lee tlee2</P></BODY></HTML> Fri, 12 Oct 2012 21:38:45 GMT https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93650#M19747 Roger 2012-10-12T21:38:45Z Re: SUBSTR function Not working! Please help me to solve the following: https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93651#M19748 <HTML><HEAD></HEAD><BODY><P>You could try something like:</P><P></P><P>data have (drop=_:);</P><P>  input;</P><P>  _infile_=transtrn(_infile_,"(","");</P><P>  call scan(_infile_, 2, _position, _length, '@', 'o');</P><P>  call scan(substr(_infile_,1,_position-2), -1,_position2, _length2);</P><P>  Full_Name=strip(substr(_infile_,1,_position2-1));</P><P>  Account_ID=substr(_infile_,_position2,_length2);</P><P>  cards;</P><P><SPAN>Mary Johnson  </SPAN><A class="jive-link-email-small" href="mailto:mjohn@gmail.com">mjohn@gmail.com</A></P><P><SPAN>Mary Jonson (</SPAN><A class="jive-link-email-small" href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A><SPAN>) </SPAN><A class="jive-link-email-small" href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A></P><P><SPAN>Robin King </SPAN><A class="jive-link-email-small" href="mailto:rking@gmail.com">rking@gmail.com</A></P><P><SPAN>Tom Lee </SPAN><A class="jive-link-email-small" href="mailto:tlee@gmail.com">tlee@gmail.com</A></P><P><SPAN>Tom Lee (</SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A><SPAN>) </SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A></P><P>;</P></BODY></HTML> Thu, 29 Nov 2012 15:10:08 GMT https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93651#M19748 art297 2012-11-29T15:10:08Z Re: SUBSTR function Not working! Please help me to solve the following: https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93652#M19749 <HTML><HEAD></HEAD><BODY><P>Here is a PRX approach:</P><P></P><P>data have (drop=_:);</P><P>length full_name account_id $40.;</P><P>_name=prxparse("/[^@\(\)]+ /");</P><P>_id=prxparse("/\w+(?=@)/");</P><P>  input;</P><P>  call prxsubstr(_name,_infile_,_s1,_l1);</P><P>  call prxsubstr(_id,_infile_,_s2,_l2);</P><P>  full_name=substr(_infile_,_s1,_l1);</P><P>  account_id=substr(_infile_,_s2,_l2);</P><P>  cards;</P><P><SPAN>Mary Johnson </SPAN><A class="jive-link-email-small" href="mailto:mjohn@gmail.com">mjohn@gmail.com</A></P><P><SPAN>Mary Jonson (</SPAN><A class="jive-link-email-small" href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A><SPAN>) </SPAN><A class="jive-link-email-small" href="mailto:mjohn2@gmail.com">mjohn2@gmail.com</A></P><P><SPAN>Robin King </SPAN><A class="jive-link-email-small" href="mailto:rking@gmail.com">rking@gmail.com</A></P><P><SPAN>Tom Lee </SPAN><A class="jive-link-email-small" href="mailto:tlee@gmail.com">tlee@gmail.com</A></P><P><SPAN>Tom Lee (</SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A><SPAN>) </SPAN><A class="jive-link-email-small" href="mailto:tlee2@gmail.com">tlee2@gmail.com</A></P><P>;</P><P>proc print;run;</P><P></P><P></P><P>Haikuo</P></BODY></HTML> Thu, 29 Nov 2012 17:18:04 GMT https://communities.sas.com/t5/SAS-Programming/SUBSTR-function-Not-working-Please-help-me-to-solve-the/m-p/93652#M19749 Haikuo 2012-11-29T17:18:04Z