Ignoring zip codes which include letters

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Ignoring zip codes which include letters

Hi,

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.

How can I tell SAS to ignore those but keep the proper ones such as 60457.

Thank you


Accepted Solutions
Solution
‎06-27-2014 08:19 AM
Super User
Posts: 9,691

Re: Ignoring zip codes which include letters

if anyalpha(zip) then delete ;

View solution in original post


All Replies
Solution
‎06-27-2014 08:19 AM
Super User
Posts: 9,691

Re: Ignoring zip codes which include letters

if anyalpha(zip) then delete ;

New Contributor
Posts: 2

Re: Ignoring zip codes which include letters

It works. Thank you.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 155 views
  • 0 likes
  • 2 in conversation