=========================================================================
Date:         Fri, 7 Jul 2006 14:42:57 -0400
Reply-To:     Mahbub Khandoker <Mahbub_Khandoker@camh.net>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Mahbub Khandoker <Mahbub_Khandoker@camh.net>
Subject:      Re: Truncating zip code
Comments: To: "Frommelt, Allen" <Frommelt@chime.org>
Content-Type: text/plain; charset="iso-8859-1"

HI Allen,
You can try this,
data list list / ZIP(a9).
begin data.
064513330
075101210
123456789
end data.

STRING ZIP_five(A5).
COMPUTE ZIP_five=RTRIM(SUBSTR(ZIP,INDEX(ZIP,',')+1)).
EXECUTE.

Cheers!
Mahbub

 -----Original Message-----
From:   SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]  On Behalf Of Frommelt, Allen
Sent:   7-Jul-06 2:28 PM
To:     SPSSX-L@LISTSERV.UGA.EDU
Subject:             Truncating zip code

I am interested in mapping patient origin from zip code. Our zip codes are currently 9 character strings, but our mapping software can only read five character zip codes. Does anyone on the list know of a method in SPSS that will allow me to create a 5 character zip code variable by lopping off the last four characters (e.g., 06451333 would become 06451).

Thanks