topic Re: Asking Advices regarding SAS GEOdist Function in Statistical Procedures

Asking Advices regarding SAS GEOdist Function

Yondori — Thu, 17 Jul 2014 06:54:18 GMT

Ksharp — Thu, 17 Jul 2014 14:22:50 GMT

SQL + geodis() -- sorry I have forgetton. You need check documentation. Here is dummy code.

proc sql;

create table distance as

select a.* ,b.id as _id, geodis(.......) as distance

from have a, have b;

quit;

after that you need transpose your table distance to get final output.

Xia Keshan

ballardw — Thu, 17 Jul 2014 14:49:40 GMT

Syntaxt for

GEODIST(latitude-1, longitude-1, latitude-2, longitude-2 <,options>)

so use Ksharps code and bring in the b version of lat and long :

add to the select statement

b.longitude as blong, b.latitude as blat, geodist (latitude, longitude, blat, blong) as distance

you may likely want the store from the b data set as well so you know which distance which would bring up b.id as bstore in the select as well.

Yondori — Mon, 21 Jul 2014 01:24:43 GMT

Thanks to all. I finally found 'how to'.