Date: Mon, 5 Jan 2009 18:46:33 -0500
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: geocoding
Scott,
In addition to the great papers that Lex provided, and the formulas and
functions that Mike and others have mentioned, you might want to take a
look at:
http://www.juiceanalytics.com/writing/excel-geocoding-tool-v2/
It appears to be an Excel program that does exactly what you want. In
fact, you might be able to develop some dde code that will run it, via
SAS, on a list of addresses.
Please post your final solution to SAS-L.
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
>
| 
