Solved: Ignoring zip codes which include letters

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

Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

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

if anyalpha(zip) then delete ;

2 REPLIES 2

Super User

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

if anyalpha(zip) then delete ;

Calcite | Level 5

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

It works. Thank you.