topic Re: Ignoring zip codes which include letters in SAS Programming https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158038#M263090 <HTML><HEAD></HEAD><BODY><P>It works. Thank you.</P></BODY></HTML> Fri, 27 Jun 2014 12:23:57 GMT magsbie 2014-06-27T12:23:57Z Ignoring zip codes which include letters https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158036#M263088 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a data which needs a lot of cleaning. One of the issue is that some of the zip codes include a letter for example 606NZ. </P><P>How can I tell SAS to ignore those but keep the proper ones such as 60457.</P><P></P><P>Thank you</P></BODY></HTML> Fri, 27 Jun 2014 11:47:24 GMT https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158036#M263088 magsbie 2014-06-27T11:47:24Z Re: Ignoring zip codes which include letters https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158037#M263089 <HTML><HEAD></HEAD><BODY><P>if anyalpha(zip) then delete ;</P></BODY></HTML> Fri, 27 Jun 2014 12:19:48 GMT https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158037#M263089 Ksharp 2014-06-27T12:19:48Z Re: Ignoring zip codes which include letters https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158038#M263090 <HTML><HEAD></HEAD><BODY><P>It works. Thank you.</P></BODY></HTML> Fri, 27 Jun 2014 12:23:57 GMT https://communities.sas.com/t5/SAS-Programming/Ignoring-zip-codes-which-include-letters/m-p/158038#M263090 magsbie 2014-06-27T12:23:57Z