topic Re: Valid email address: in SAS Programming

topic Re: Valid email address: in SAS Programming https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107264#M22342 <HTML><HEAD></HEAD><BODY><P>One way:</P><P></P><P>proc freq data=have;</P><P>tables email;</P><P>where index(email, '----');</P><P>run;</P><P></P><P>It will print a table based on any email addresses that contain four dashes in a row, anywhere within the address.  If you want to cut it to less than 4, that's up to you.  You know your data best.</P><P></P><P>Good luck.</P></BODY></HTML> Tue, 12 Feb 2013 22:27:39 GMT Astounding 2013-02-12T22:27:39Z Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107262#M22340 <HTML><HEAD></HEAD><BODY><P><BR />As a first step towards data cleaning:</P><P></P><P>How to get the counts of following where there just hypens before @ in email addresses:</P><P><A href="mailto:------------------------------------@GMAIL.COM">------------------------------------@GMAIL.COM</A></P><P><A href="mailto:-------------@-------------.COM">-------------@-------------.COM</A></P><P><A href="mailto:-------------@YAHOO.COM">-------------@YAHOO.COM</A></P><P><A href="mailto:------------@EMC.COM">------------@EMC.COM</A></P><P><A href="mailto:----------@HOTMAIL.COM">----------@HOTMAIL.COM</A></P><P><A href="mailto:----------@YAHOO.COM">----------@YAHOO.COM</A></P><P><A href="mailto:---------@PRTC.NET">---------@PRTC.NET</A></P><P><A href="mailto:---------@--.COM">---------@--.COM</A></P><P><A href="mailto:--------@AOL.COM">--------@AOL.COM</A></P><P><A href="mailto:abc@gmail.com">abc@gmail.com</A></P></BODY></HTML> Tue, 12 Feb 2013 21:40:40 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107262#M22340 SASPhile 2013-02-12T21:40:40Z Re: Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107263#M22341 <HTML><HEAD></HEAD><BODY><P>You will probably need some Regular expression:</P><P></P><P>data have;</P><P>  input email :$char100.;</P><P>  cards;</P><P><SPAN>  </SPAN><A class="jive-link-email-small" href="mailto:------------------------------------@GMAIL.COM">------------------------------------@GMAIL.COM</A></P><P>-------------@-------------.COM</P><P><A class="jive-link-email-small" href="mailto:-------------@YAHOO.COM">-------------@YAHOO.COM</A></P><P><A class="jive-link-email-small" href="mailto:------------@EMC.COM">------------@EMC.COM</A></P><P><A class="jive-link-email-small" href="mailto:----------@HOTMAIL.COM">----------@HOTMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:----------@YAHOO.COM">----------@YAHOO.COM</A></P><P><A class="jive-link-email-small" href="mailto:---------@PRTC.NET">---------@PRTC.NET</A></P><P>---------@--.COM</P><P><A class="jive-link-email-small" href="mailto:--------@AOL.COM">--------@AOL.COM</A></P><P><A class="jive-link-email-small" href="mailto:abc@gmail.com">abc@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:mike-smith@tg-aol.com">mike-smith@tg-aol.com</A></P><P>;</P><P></P><P>data want;</P><P>set have;</P><P>  if prxmatch("/^-+@/",email) then ind=1;</P><P>run;</P><P>proc print;run;</P><P></P><P>Haikuo</P></BODY></HTML> Tue, 12 Feb 2013 22:24:13 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107263#M22341 Haikuo 2013-02-12T22:24:13Z Re: Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107264#M22342 <HTML><HEAD></HEAD><BODY><P>One way:</P><P></P><P>proc freq data=have;</P><P>tables email;</P><P>where index(email, '----');</P><P>run;</P><P></P><P>It will print a table based on any email addresses that contain four dashes in a row, anywhere within the address.  If you want to cut it to less than 4, that's up to you.  You know your data best.</P><P></P><P>Good luck.</P></BODY></HTML> Tue, 12 Feb 2013 22:27:39 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107264#M22342 Astounding 2013-02-12T22:27:39Z Re: Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107265#M22343 <HTML><HEAD></HEAD><BODY><P>I had to ask, what if you want to keep:</P><P><A class="jive-link-email-small" href="mailto:abc-xyz@gmail.com">abc----xyz@gmail.com</A></P><P>but to drop:</P><P><A class="jive-link-email-small" href="mailto:-@gmail.com">----@gmail.com</A><SPAN>?</SPAN></P><P></P><P>I still think the Regular expression is the way to go, at least for the first step.</P><P></P><P>my 2 cents,</P><P></P><P>Haikuo</P></BODY></HTML> Tue, 12 Feb 2013 22:32:22 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107265#M22343 Haikuo 2013-02-12T22:32:22Z Re: Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107266#M22344 <HTML><HEAD></HEAD><BODY><P><A __default_attr="504807" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A>: Since you wanted strings that start with any number of hyphens, then followed with an @, I'll suggest adding one more character to Haikuo's code.  The ^ at the beginning forces the match to have occurred at the start of the string:</P><P></P><P>data have;</P><P>  informat email $50.;</P><P>  input email;</P><P>  cards;</P><P><A class="jive-link-email-small" href="mailto:------------------------------------@GMAIL.COM">------------------------------------@GMAIL.COM</A></P><P>-------------@-------------.COM</P><P><A class="jive-link-email-small" href="mailto:-------------@YAHOO.COM">-------------@YAHOO.COM</A></P><P><A class="jive-link-email-small" href="mailto:------------@EMC.COM">------------@EMC.COM</A></P><P><A class="jive-link-email-small" href="mailto:x----------@HOTMAIL.COM">x----------@HOTMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:----------@YAHOO.COM">----------@YAHOO.COM</A></P><P><A class="jive-link-email-small" href="mailto:---------@PRTC.NET">---------@PRTC.NET</A></P><P>---------@--.COM</P><P><A class="jive-link-email-small" href="mailto:--------@AOL.COM">--------@AOL.COM</A></P><P><A class="jive-link-email-small" href="mailto:abc@gmail.com">abc@gmail.com</A></P><P>;</P><P>data want;</P><P>  set have;;</P><P>  if prxmatch("/^-+@/",email) then ind=1;</P><P>run;</P></BODY></HTML> Tue, 12 Feb 2013 22:34:47 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107266#M22344 art297 2013-02-12T22:34:47Z Re: Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107267#M22345 <HTML><HEAD></HEAD><BODY><P> DATA WANT;</P><P>SET HAVE;</P><P>if index(email,'@')-1 = countc(substr(email,1,index(email,'@')-1),'-');</P><P>run;</P></BODY></HTML> Tue, 12 Feb 2013 22:47:43 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107267#M22345 DBailey 2013-02-12T22:47:43Z Re: Valid email address: https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107268#M22346 <HTML><HEAD></HEAD><BODY><P>I suppose I could switch from this:</P><P></P><P>index(email, '----')</P><P></P><P>to this:</P><P></P><P>index(email, <A href="mailto:'-@'">'-@'</A>)</P></BODY></HTML> Wed, 13 Feb 2013 02:51:50 GMT https://communities.sas.com/t5/SAS-Programming/Valid-email-address/m-p/107268#M22346 Astounding 2013-02-13T02:51:50Z