topic Re: PROC GMAP - Is a network type map possible? in Graphics Programming

PROC GMAP - Is a network type map possible?

Jim_Ogilvie — Fri, 07 Feb 2020 15:07:27 GMT

Hi all,

I would like to do some sales analysis based on despatching depot and customer delivery location (destination), displayed on a map with the depots and destinations linked.

I have a measure for volume sold for each customer, lat/longs for each customer and lat/longs for each depot.

Is it possible to use PROC GMAP to create a network diagram on a map?

Thanks in advance

Jim

Re: PROC GMAP - Is a network type map possible?

ChrisHemedinger — Fri, 07 Feb 2020 15:12:14 GMT

Check out this example for PROC SGPLOT. If your data are prepped properly, this might work for you.

Re: PROC GMAP - Is a network type map possible?

Jim_Ogilvie — Fri, 07 Feb 2020 15:24:40 GMT

Thanks Chris.

I can see how I could get my data into a shape to construct this, but after that step, what how could this be presented on a map?

Annotate perhaps?

Re: PROC GMAP - Is a network type map possible?

ChrisHemedinger — Fri, 07 Feb 2020 15:33:33 GMT

There is another SAS procedure called SGMAP that can bring in maps (Esri and OpenStreet). We have plenty of examples on our support.sas.com site and in the Graphically Speaking blog.

Now, how to overlay the network arcs? That's beyond me, but maybe others (like @GraphGuy) can chime in.

Re: PROC GMAP - Is a network type map possible?

Jim_Ogilvie — Fri, 07 Feb 2020 15:35:48 GMT

Many thanks Chris.

Awaiting input from others in anticipation......

Re: PROC GMAP - Is a network type map possible?

ChrisNZ — Wed, 12 Feb 2020 20:30:52 GMT

Proc GMAP allows you to do what you want using annotate data sets.

Proc SGMAP will probably look better, but I don't think it allows superposition of arrows.

You can fool it into drawing connecting lines by using the SERIES statement.

[Edit: That's what Robert does below]

Re: PROC GMAP - Is a network type map possible?

ChrisNZ — Tue, 11 Feb 2020 13:47:22 GMT

This might interest you:

Example 10.7 Traveling Salesman Tour of US Capital Cities

Re: PROC GMAP - Is a network type map possible?

ChrisNZ — Wed, 12 Feb 2020 01:02:54 GMT

@ChrisHemedinger Much better presented. Thanks!

Re: PROC GMAP - Is a network type map possible?

GraphGuy — Wed, 12 Feb 2020 12:25:28 GMT

Here's an example using SAS/Graph's Proc Gmap and annotate:

Description:

https://blogs.sas.com/content/sastraining/2016/08/25/how-close-are-you-to-a-nuclear-plant/

SAS code:

http://robslink.com/SAS/democd88/nuclear_distance.sas

I'll see if I can convert it to Proc SGmap (so users who don't have SAS/Graph can create something similar).

Re: PROC GMAP - Is a network type map possible?

GraphGuy — Wed, 12 Feb 2020 14:36:48 GMT

Here's a similar map created with Proc SGmap (which is in Base SAS). You should be able to do all the graphical stuff with 9.4m6, but if you want the custom mouse-over text and drilldown capability you'll need the very recently-released Viya 3.5.

Map with mouse-over text and drilldowns:

http://robslink.com/SAS/ods10/nuclear_distance.htm

SAS Code:

http://robslink.com/SAS/ods10/nuclear_distance.sas

PNG Image: