topic Re: Calculate distance in miles from 1 lat/long against several lat/longs for addresses. in SAS Programming

Calculate distance in miles from 1 lat/long against several lat/longs for addresses.

aarnold18 — Mon, 11 Mar 2024 18:54:07 GMT

Hi I have a table that I created using proc sql;

I have the latitude and longitude values for a single location (A) and then in the table I created, I have the latitude and longitude values for every address in the table. I am trying to create a flag that marks specific people within 5 miles or 10 miles from location A.

Can anyone tell me how I can create another column in the table I created that calculates the distance in miles for each row compared to the single location (A)?

Re: Calculate distance in miles from 1 lat/long against several lat/longs for addresses.

data_null__ — Mon, 11 Mar 2024 19:05:25 GMT

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

Re: Calculate distance in miles from 1 lat/long against several lat/longs for addresses.

ballardw — Mon, 11 Mar 2024 19:13:07 GMT

If you are asking for straight-line distance and not road distance you can use the GEODIST function.

If this is really for just one point compared with others than you could hard code the single location into the function call and just use the other data set as the source.

The code would look like:

data want;
    set have; /*this has the addresses of interest*/
   distance = geodist(fixedLat, FixedLong, addressLat, addressLong,'M');
run;

actually to go with the function you specify whether the lat and long are in Degrees or Radians by using "DM" or "RM". The M says the result will be in miles.

Fixedlat and Fixedlong are the lat and long of the one point you want to use with all the records.

Re: Calculate distance in miles from 1 lat/long against several lat/longs for addresses.

aarnold18 — Mon, 11 Mar 2024 19:26:16 GMT

thank you,

I tried this (fake target lat/long):

%let target_lat = 12.00000;
%let target_long = -40.0000;

data want;

set *table with all the addresses*;

distance = geodist(&target_lat, &target_long, latitude, longitude, 'M');

where latitude and longitude are the column names in the table with all the addresses.

Unfortunately this code runs but it only gives the following columns: distance, latitude, longitude, longitude and they are all blanks.

Re: Calculate distance in miles from 1 lat/long against several lat/longs for addresses.

aarnold18 — Mon, 11 Mar 2024 19:47:07 GMT

nevermind I had the wrong table referenced, this solved it - thank you!

Re: Calculate distance in miles from 1 lat/long against several lat/longs for addresses.

ballardw — Mon, 11 Mar 2024 20:16:29 GMT

@aarnold18 wrote:

nevermind I had the wrong table referenced, this solved it - thank you!

I've used SAS for over 30 years. If you believed me when I said that I never used the wrong data set I would be looking for that deed I have to the Brooklyn Bridge to sell it to you. 😉