Click here to see the SAS code.
Click here to see the example.

Click here to see the SAS code for the drilldowns.
Click here to see the SAS code for the drilldowns.

Click here to see the SAS code (for the drilldown grids).

---------------------------------------------------------------

Borehole Data:
http://www.gomr.mms.gov/homepg/pubinfo/freeasci/well/boreholedatadfn.html
http://www.gomr.mms.gov/homepg/pubinfo/freeasci/well/zipped/fixed/5010.zip
5010.zip->5010.DAT

In this example, I'm plotting each individual well/drill-hole on a map.

I use the following annotate code to get the tiny markers for the wells...

function='label';
color='red';
position='5';
style='"wingdings"';
text='6c'x;
size=.40;

In the drilldown maps, I let you click on the individual wells to get a report
on that well -- ideally this would be a drilldown to detailed produciton info, etc.
That info is a bit hard to get, so as a proof-of-concept compromise, I just drilldown
to the line in a table (via an html anchor) showing the basic info I do have.  

The technique I used for this was a bit clever (I've never seen it used before) ...
I define a user-defined-format on-the-fly (using cntlin) such that the well hole numbers
also print an html anchor when I print them in "ods html" proc print.  This way, there
is an html anchor for each line which I can jump to (but the text of the html anchor 
does not visually show up).  This code is in 'grid.sas'.



Back to Samples Index