Date: Thu, 22 Sep 2005 07:36:00 +1000
Reply-To: Simon Freidin <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Simon Freidin <email@example.com>
Subject: Re: 2nd Attempt: Grouping Zip Codes
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
data list list /origin (a5) Zip1 Zip2 Zip3 .
Zip1 0 5 15
Zip2 5 0 12
Zip3 15 12 0
sel if index(case_lbl,'ORIGIN')=0.
match files file=*/drop=var001.
formats lt10 (f1).
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
> Now, we need to group the zip codes which fall within 10 minutes of
> 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
> problem or any suggested approaches that come to mind for a possible
> solution or any suggested texts which I can use to tackle this
> Best regards
> Deepak Jethwani