Desktop productivity for business analysts and programmers

making route for intensive points with decimal coordiantes

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

 

LATITLONGIProvinceCity
36,6088334,32703neverlandnowhere
36,7130234,33731neverlandnowhere
36,4580434,15251neverlandnowhere
36,6338634,34518neverlandnowhere
36,6094934,31894neverlandnowhere
36,4583234,14116neverlandnowhere
36,5517834,23458neverlandnowhere
36,5935234,28714neverlandnowhere

Accepted Solutions
Solution
2 weeks ago
Esteemed Advisor
Posts: 7,290

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

 

View solution in original post


All Replies
Solution
2 weeks ago
Esteemed Advisor
Posts: 7,290

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

thank you for swift reply!

 

Now i must improve my coding technique on SAS Smiley Happy

 

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 136 views
  • 0 likes
  • 2 in conversation