9月 122016

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 […]

Nine years (and still together) was published on SAS Voices.

12月 042015

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. […]

The post Workload optimization – Are you balanced? appeared first on The Data Roundtable.

9月 262012
As I mentioned in my last blog post, Analytics 2012 will offer you opportunities to hear from a few of our valued partners, including Teradata, who will be hosting three roundtable discussions that are sure to satisfy your analytics appetite: The Analytic Challenges of Unstructured Data Considerations for Determining Analytic [...]
9月 212012
The League of Analytic Heroes is growing.  With the addition of each new member, we are better able to combat the chaos of big data. Illumino and Magnacomm are eager to welcome their newest team member. Keep your eyes on www.analyticheroes.com for his arrival.  He's already got his eye on [...]
4月 252012

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.

tags: papers & presentations, PROC REPORT, PROC SQL, SAS Global Forum, teradata
4月 252012
Bill Franks’s new book, Taming the Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics, has just released. This book shows how big data is changing the world of analytics; what people, processes, technologies, and mindsets are necessary to succeed in analytics in this new era; [...]
4月 242012
SAS Global Forum is known for excitement and surprises. So far, this year has been no different.   It all started on Sunday when Teradata Chief Analytics Officer, Bill Franks, was reported missing.  His absence was especially noticeable because he was expected to promote his new book, Taming the Big Data [...]