making route for intensive points with decimal coordiantes

[tevfik]

Hi,

i am new on sas enterprise guide (7.11 version) so that reason my question sounds silly

i want to make routes for field teams for intensive points. I have data-set which includes decimal points at a city and i want to define 1km diameter-length fields which includes min 60 max 80 points.  To make this i took the center point (decimal) of the city and try to calculate the distance (haversine formula) from center and later making group of them which 1km distance interval but i can not make it right. Have you any advice or how can i make the distance calculation? 

By the way i am using computed columns to take this action not programming. Thank you in advance

Note: Geodist function does not exist in 7.11 version of SAS Enterprise Guide

LATIT	LONGI	Province	City
36,60883	34,32703	neverland	nowhere
36,71302	34,33731	neverland	nowhere
36,45804	34,15251	neverland	nowhere
36,63386	34,34518	neverland	nowhere
36,60949	34,31894	neverland	nowhere
36,45832	34,14116	neverland	nowhere
36,55178	34,23458	neverland	nowhere
36,59352	34,28714	neverland	nowhere

[art297 · Accepted solution]

You can calculate the distances without needing the geodist function. Take a look at: http://www.sascommunity.org/wiki/Driving_Distances_and_Drive_Times_using_SAS_and_Google_Maps

Then, I'd use proc modeclus to find the closest 60 or 80 points. Code is provided at: http://www.sas-programming.com/2013/05/finding-closest-pair-in-dataset-using.html

Art, CEO, AnalystFinder.com

[tevfik]

thank you for swift reply!

Now i must improve my coding technique on SAS 🙂

it s a bit hard for me because i m new on SAS Enterprise Guide