First I read up about the spill on various news sites. It appears this was a 36 inch underground pipeline owned by the Colonial Pipeline Company, that supplied 1.3 million barrels of gasoline a day. The break is in a rural area southwest of Birmingham, Alabama. For some of the states supplied by this pipeline, there are not a lot of other options for getting gasoline.
I did a bit of web searching, and found a shapefile for "Petroleum Product Pipelines". I downloaded and extracted the zip file, and then used Proc MapImport to convert it into a SAS dataset. The dataset contained lat/long coordinates along the various pipelines, and from there it was simply a matter of coming up with a bit of clever SAS code to annotate the pipeline data on a US map.
Here's what I came up with:
Is your state supplied by this pipeline? Are you seeing shortages yet? How long do you think it will take to repair the pipeline?
This content was reposted from SAS Learning Post. Go there to view the original post.