Solved: Ignoring zip codes which include letters - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Ignoring zip codes which include letters

Posted 06-27-2014 07:47 AM (860 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Ignoring zip codes which include letters

Posted 06-27-2014 08:19 AM (967 views) | In reply to magsbie

if anyalpha(zip) then delete ;

View solution in original post

2 REPLIES 2

Super User

Super User

Re: Ignoring zip codes which include letters

Posted 06-27-2014 08:19 AM (968 views) | In reply to magsbie

if anyalpha(zip) then delete ;

Calcite | Level 5

Calcite | Level 5

Re: Ignoring zip codes which include letters

Posted 06-27-2014 08:23 AM (830 views) | In reply to Ksharp

It works. Thank you.