Home » Coding & Data

SAS BI: Sample Data for Facial Recognition and UFOs

Submitted by on November 4, 2011 – 7:00 am

Oh my goodness … Christmas has come early children! You must have been extra good this year because look what all I have found!  A few times before I have discussed where to find SAS sample data sources and even how to create your own sample data.

While learning the SAS Business Intelligence package, it is more fun to work with data that you find interesting so you can search out the trends yourself.  It also helps you think through how the user would want to setup the data for Web Report Studio reporting and what stored processes you would create to support the system.  

Use the following sources to practice building an information map or even get crazy and code yourself a cube using PROC OLAP.  Along the way, see what issues you run into trying to create time series data, join tables by variables, how to deal with duplicate entries, and other issues you only run into when you are actually doing it (aka experience). 

Get Your Data Geek On 

sas_bi_data_geek

From istockphoto.com through MS Office Clipart

This tip came from  Twitter user One R Tip a Day who recommended the Finding Data on the Internet post. Most of the data sources are in CSV format so easy for you to use SAS Enterprise Guide to grab and turn into a SAS dataset in a simple click (oh! snap!).

One site that really intrigued me was Kaggle, who hosts data competitions.  This site is like a party just for data geeks! One competition that looked fun to me was Don’t Get Kicked! sponsored by Carvana (Sell no Evil is their motto).  You can win $5K by predicting if a car from auction is a lemon.  Come on – I know you can do it. As a bonus I’m willing to split the prize with you based on my excellent moral support.

Facial Recognition and UFO Data?

Here’s a website that has facial recognition data for a homework assignment – although I’m not sure what a BI analyst would do with it. There’s even more facial recognition data at the Face Recognition site. Wow, starting to get a little creepy. Remind me to keep my Halloween mask on while in public. 

sas_bi_data_UFO_detail

Speaking of creepy here’s the National UFO Reporting Center data.  The data is really interesting. The site has it indexed several ways: (i.e. location and date).  

I got the data for North Carolina (where I am) and turns out people in Charlotte reported seeing more UFO than other areas of the state. For the past five years, there were more reports during the month of July.  Guess the outer space beings prefer that time to vacation as well.

Someone out there should be able to cross index the facial recognition data with the aliens to figure out which galaxy produces the most attractive ones. I’m biased toward the Milky Way.

<

Never miss a post!

Get the latest BI Notes post in your Inbox when a new post is released! Click here for free subscription. You email address is kept private and you can unsubscribe anytime. Go ahead ... join us!

Related content:

  1. Create Your Own Sample Data for SAS BI
  2. SAS BI: Sample Data Sources
  3. SAS Enterprise Guide – Tips & Tricks for Editing a Data Table Directly
  4. SAS Coding: 3 Data Set Tricks in PROC SQL
  5. Is Google Analytics and SAS BI a Good Subject?
The following two tabs change content below.
My Twitter profileMy Google+ profileMy LinkedIn profile

Tricia Aanderud

SAS Consultant at Zencos
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has over 10 years of SAS programming experience. Contact her for assistance with your next project.

Tags: , ,