Solved
New Contributor
Posts: 2

making route for intensive points with decimal coordiantes

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

Accepted Solutions
Solution
‎07-10-2017 07:04 AM
Super User
Posts: 8,218

Re: making route for intensive points with decimal coordiantes

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

All Replies
Solution
‎07-10-2017 07:04 AM
Super User
Posts: 8,218

Re: making route for intensive points with decimal coordiantes

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

New Contributor
Posts: 2

Re: making route for intensive points with decimal coordiantes

Now i must improve my coding technique on SAS

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

☑ This topic is solved.