Date:         Thu, 22 Sep 2005 07:36:00 +1000
Reply-To:     Simon Freidin <simonpf@unimelb.edu.au>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Simon Freidin <simonpf@unimelb.edu.au>
Subject:      Re: 2nd Attempt: Grouping Zip Codes
Comments: To: Deepak Jethwani <deepak.jethwani@gmail.com>
In-Reply-To:  <2084e73d05092106191927dad6@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

data list list /origin (a5) Zip1 Zip2 Zip3 .
begin data.
Zip1 0 5 15
Zip2 5 0 12
Zip3 15 12 0
Zip4
end data.

casestovars/separator='_'.
flip.
sel if index(case_lbl,'ORIGIN')=0.
compute lt10=(var001<10).
match files file=*/drop=var001.
formats lt10 (f1).
list.

CASE_LBL LT10

ZIP1_1     1
ZIP1_2     1
ZIP1_3     0
ZIP1_4     .
ZIP2_1     1
ZIP2_2     1
ZIP2_3     0
ZIP2_4     .
ZIP3_1     0
ZIP3_2     0
ZIP3_3     1
ZIP3_4     .


Number of cases read:  12    Number of cases listed:  12



On 21/09/2005, at 11:19 PM, Deepak Jethwani wrote:

> Hi Listers,
>  This is my second mail to the list. I am still struggling with the
> following issue.
>  We have a list of zip codes and a table that lists out the drive time
> distance from one zip code to the other in the following format.
>
> Zip1 Zip2 Zip3 .....
> Zip1 0 5 15
> Zip2 5 0 12
> Zip3 15 12 0
> Zip4
>
>
>
> Now, we need to group the zip codes which fall within 10 minutes of
> drive
> time distance from a zip code into a group.
>  The problem is actually about identifying starting zip codes
> around which
> to build these groupings.
>
> I would really welcome any comments from anyone who has faced a
> similar
> problem or any suggested approaches that come to mind for a possible
> solution or any suggested texts which I can use to tackle this
> problem.
>
> Best regards
>  Deepak Jethwani
>