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
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset=US-ASCII

Hello,
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
0S356 MADISON
0S531 JEFFERSON

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.

Thanks,

Duckhye