The IT industry is littered with examples of short-lived corporate partnerships and alliances that often appear impressive but regularly end or are withdrawn after the initial enthusiasm wanes. The old adage that “actions speaker louder than words” is especially pertinent and I regularly encourage clients to look for tangible examples […]
The other day I was chatting with an ETL developer and he said he always pushes queries into the database instead of dragging data across the network. I thought “Hmm, I remember talking about those topics when I was a DBA.” I'd like to share those thoughts with you now. […]
Disasters happen every day. Often times they occur at inconvenient hours and in remote locations. So it’s important to have a plan - before the emergency - to get qualified personnel to those locations in the most efficient way. Pilots are an example of qualified personnel who could act as “first responders” in these situations.
At SAS Global Forum 2012, I saw a presentation by Andrew Hummel, General Manager, Crew Resources at Delta Air Lines about his use of SAS to create a US “First Responders Directory” by aligning pilot residences with airport locations. Now that’s preparation for the unknown.
Delta Air Lines operates formal corporate emergency response teams, but those are often set up in centralized locations and may not be as effective when responding to disasters in rural areas or during non-business hours. That’s where the pilots come in. Throughout the US, Delta Air Lines has more than 10,000 pilots who could act as first responders to the more than 250 airports that are sites designated to respond to emergencies. Identifying which pilots live the closest to airports through a directory is critical information during a crisis when those pilots could be called to drive to the airport immediately, at any time of day.
How did Delta Air Lines create the directory? SAS can calculate the distance (in miles) between two points through ZIP codes and longitudinal and latitudinal data. The team first gathered longitudinal and latitudinal coordinates for each airport and ZIP codes of pilot’s homes – all data found within a Teradata data warehouse.
And we're talking about a ton of data here, given the number of pilots across the country. But SAS is able to compute the resulting 3 million calculations in a matter of seconds. The final directory lists how far each pilot lives from each airport, see example report created by PROC REPORT below (click to enlarge).
Delta Air Lines can then quickly match first responders to any emergency location in the US.
Check out the full paper to see exactly how the report was developed. Can SAS be applied to create critical information for a crisis in your industry? Feel free to share those examples in the comments.