Date: Mon, 23 Feb 2004 15:00:16 -0600
Reply-To: Duck-Hye Yang <dyang@CHAPINHALL.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Duck-Hye Yang <dyang@CHAPINHALL.ORG>
Subject: need help with cleaning up address
Content-Type: text/plain; charset=US-ASCII
I need to clean up address data. The following has some examples:
0 S 336 EAST STREET
0 S 356 MADISON
0 SOUTH 531 JEFFERSON
0416 E. BAILEY 101
I need to combine the three items for the first three records. The desired output looks like the following:
0S336 EAST STREET
For the last address --- 0416 E. BAILEY 101, I need to remove the zero from the beginning so that that the address becomes "416" instead of "0416".
My address data also contains many normal-looking addresses, such as 100 S. LaSalle ST
So, I need to isolate only problematic addresses from non-problematic addresses first, I think.