Date:         Sun, 4 Jan 2009 18:54:20 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      How to get info from a website

On Sun, 4 Jan 2009 15:31:41 -0800, ajay ohri <ajayohri@YAHOO.COM> wrote:

>Arthur,
>
>Sorry I cant provide the entire code for free.
>
>DO try and Download Google Earth , and then do a sample search yourself,
save the file as a kml file.Basically the code automates it,and it is not
in SAS language.
>
> After that I can give you some VBA code to extract the long lat from the
kml file, and an excel template/web path to calculate distance between the
points.
>
>I hope you meant automatically and not auto magically ?
>
>Regards,
>
>Ajay
>
>www.decisionstats.com
>
>
>
>--- On Mon, 1/5/09, Arthur Tabachneck <art297@NETSCAPE.NET> wrote:
>
>> From: Arthur Tabachneck <art297@NETSCAPE.NET>
>> Subject: Re: geocoding
>> To: SAS-L@LISTSERV.UGA.EDU
>> Date: Monday, January 5, 2009, 4:49 AM
>> Scott,
>>
>> Two questions:
>>
>> 1. Do your addresses contain just the street number, name,
>> city and
>> province/state, or do they also contain postal and/or zip
>> codes?
>>
>> 2. How fine does your analysis have to be?
>>
>> I can only talk about Canadian postal codes but, regarding
>> them, Google
>> Earth may provide a good alternative IF you only need to
>> group by the
>> first three characters of the postal code (i.e., the
>> equivalent of a
>> metropolitan sorting area).  If you need to be as exact as
>> a city block,
>> then I'm not aware of any free alternative.
>>
>> Ajay, can you provide some sample code (whether it be SAS
>> or VBA) to get
>> the file automagically from Google Earth?
>>
>> Art
>> --------
>> On Sun, 4 Jan 2009 14:36:01 -0600, Raynaud, Scott
>> <Scott.Raynaud@TARGETBASE.COM> wrote:
>>
>> >Yes, I Googled this topic before emailing.  The problem
>> with the
>> >services I found was I was not sure about the quality,
>> they only do US,
>> >or there is no way to process a batch job.  Since I
>> have 200k records,
>> >doing them one-by-one is not an option.  I found one
>> site that allows
>> >batch processing (stevemorse.org), but one is limited
>> to about 100-150
>> >records at a time.  Anyway, GIS is not my forte, so it
>> would be nice to
>> >know what tools are available (for free).
>> >
>> >-----Original Message-----
>> >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]
>> On Behalf Of
>> >Daniel Nordlund
>> >Sent: Sunday, January 04, 2009 2:22 PM
>> >To: SAS-L@LISTSERV.UGA.EDU
>> >Subject: Re: geocoding
>> >
>> >> -----Original Message-----
>> >> From: SAS(r) Discussion
>> [mailto:SAS-L@LISTSERV.UGA.EDU] On
>> >> Behalf Of Scott Raynaud
>> >> Sent: Sunday, January 04, 2009 11:39 AM
>> >> To: SAS-L@LISTSERV.UGA.EDU
>> >> Subject: geocoding
>> >>
>> >> I'm running SAS 9.1.3.  I don't have
>> SAS/GIS.  I have some
>> >> addresses (US and
>> >> Canada) that I wish to convert to lat/longs.
>> Anybody have
>> >> any ideas on how
>> >> I can accomplish this with out paying boat loads
>> of money
>> >> (read free)?  When
>> >> I searched the archives I saw a post on a software
>> called
>> >> GRASS, but the
>> >> documentation was pretty sparse.  I couldn't
>> easily figure out how to
>> >> perform the conversion.
>> >
>> >How many addresses constitute "some"?  If you
>> google "free geocoding"
>> >you
>> >will find lots of options on the web, both individual
>> and bulk
>> >geocoding.
>> >
>> >Dan
>> >
>> >Daniel Nordlund
>> >Bothell, WA USA
>> >[ALERT] -- Access Manager: This email is intended only
>> for the person or
>> entity to which it is addressed and may contain information
>> that is
>> privileged, confidential or otherwise protected from
>> disclosure.
>> Dissemination, distribution or copying of this e-mail or
>> the information
>> herein by anyone other than the intended recipient, or an
>> employee or
>> agent responsible for delivering the message to the
>> intended recipient, is
>> prohibited. If you have received this e-mail in error,
>> please immediately
>> notify us by calling our North American Help Desk at
>> (972)506-3939.
>> >
>> >Targetbase Messaging Services provided by DMSP
>> >