title: How to extract zipcode from very meshy string using regular expression in SAS?
body: <p>I am trying to extract 5 number zipcode from the address field. I have included the sample data (see below). The data has 5 digit street fields in the beginning, and also 5 digit PO Box number in the middle part and 5-9 digit zipcodes, some in middle part and some in the end of the string. my objective is to extract the 5 digit zipcode from the string but not the 5 digit street and PO Box number using regular expression in SAS. Please take a look at the sample data and help me resolve this issue. I would highly appreciate your kind assistance.</p>
  
  <pre><code>13001 NW42 AVE OPA LOCKA FL 33054 USA
  13001 NW 42 AVENUE OPA LOCKA FL 33054 USA
  PO BOX 98748 CHICAGO IL 60693 USA
  601 W 80TH STREET CHICAGO IL 60620 2502
  12651 S DIXIE HWY, SUITE 321 MIAMI,FLORIDA33156
  12713 SW 125TH AVE MIAMIFL 331865932
  </code></pre>