Previous Page | Next Page

The GINSIDE Procedure

Example 2: Mapping and Annotating Values from the GINSIDE Procedure


Procedure features:

ID statement

Sample library member: GINSIDE

[annotated output using results of PROC GINSIDE]

The following example determines which customers are inside Wake County in the state of North Carolina. It then draws a map and colors the dots (representing customers) to distinguish customers inside the county from customers outside the county. This example is featured in the SAS Sample Library under the name GINSIDE.

 Note about code
goptions reset=global border;
 Note about code
data customer;
  length city $20;
  input lastname$ zip x y city $;

cards;
Smith    27611 1.374164 0.623436 Raleigh  
Jones    27560 1.375948 0.625278 Morrisville 
Doe      27513 1.375279 0.624922 Cary  
Patel    27520 1.369120 0.621970 Clayton  
White    27705 1.377910 0.628629 Durham
Short    27587 1.370373 0.627680 WakeForest
Phillips 27591 1.368124 0.624705 Wendell
Jackson  27597 1.367264 0.625629 Zebulon
;
 Note about code
data states;
  set maps.counties(where=(fipstate(state)="NC" and county=183));
run;
 Note about code
data combined;
  set customer states;
run;
 Note about code
proc gproject data=work.combined out=work.combined dupok;
  id state county;
run;

/*split the data*/
data work.states customer;
  set work.combined;
  if missing(zip) = 1 then output work.states;
  else output customer;
run;
 Note about code
proc ginside map=work.states data=customer out=mapout;
  id state county;
run;
/*see the resulting data*/
proc print;
run;
 Note about code
data points;
   set mapout;
   length function style color $ 8 position $ 1 text $ 20 ;
   retain xsys ysys "2" hsys "3" when "a" text 
""; retain rotate 360 style "solid" function "pie" position "5"; color=
"black"; size=2; if missing(county) then color="red"; output; run; title "Red dots are outside of Wake County";
 Note about code
proc gmap data=states map=states anno=points;
  id county;
  choro county / coutline=black nolegend;
run;
quit;

Proc PRINT Results for Output Data Set shows the results of PROC PRINT. Notice that the last two observations have missing values for COUNTY because they are not in Wake County.

Proc PRINT Results for Output Data Set

         X            Y  SEGMENT  COUNTY  DENSITY  STATE  city         lastname   zip

-.001541860  -.001337843     2       183      .       .    Raleigh      Smith     27611
-.002986277  0.000506523     3       183      .       .    Morrisville  Jones     27560
-.002444482  0.000149461     4       183      .       .    Cary         Doe       27513
0.001531260  0.002906157     5       183      .       .    WakeForest   Short     27587
0.003358790  -.000065627     6       183      .       .    Wendell      Phillips  27591
0.004053658  0.000860235     7       183      .       .    Zebulon      Jackson   27597
0.002555933  -.002802349     8         .      .       .    Clayton      Patel     27520
-.004565994  0.003861845     9         .      .       .    Durham       White     27705

Previous Page | Next Page | Top of Page