BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

SAS BI: Sample Data Sources

Submitted by on 2011-09-06 – 2:00 AM

As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore.  Here is a list of free sources that I have found that can help as you learn and want to challenge yourself.

Simple Data Tables

Here are some sources for simple data tables.  These are datasets with all of the data contained in one table and do not need to join to anything else.

SASHELP

This listing of data may be most familiar to BASE SAS users. This library has several ready made data sets (i.e. SHOES, CLASS, and CARS).
If you do not see a SASHELP library in your list, then ask your SAS Administrator to add it.

SAS Enterprise Guide Data

  • EG 4.3 shipped with some fun ready-made simple datasets:  Bullets,  Drugs, and TotArrests.  [Hmmm …. ]
  • This data was located in this path on my EG 4.3  installation:
    C:\Program Files\SAS\EnterpriseGuide\4.3\Sample\Data

DATA.GOV

http://www.data.gov/ has a ton of simple raw data tables on a variety of topics: earthquake activity, income data by county for 2007, and unemployment statistics.  It is actually just fun to poke around to see what is available.

  • This site also has links to other open data sites other countries (UK, Australia, and Hong Kong) and to specific cities (Seattle, Atlanta, and New York.)
  • Not all of the data is in CSV format and some can be a challenge to import.  For BASE SAS Certification,  it may be a way to learn all the data import tricks (missover, scanover).

Relational Data Tables

If you want to practice joining table using the SAS BI tools, here are some sources for relational data tables.

SAS Enterprise Guide Data

EG 4.3 does have some relation data tables.

  • Candy Company data  (CANDY_CUSTOMERS, CANDY_PRODUCTS, CANDY_SALES_HISTORY, etc.)
    This is a good one to use in the OLAP Studio as an example star schema table.
  • Beer Sales data (BEER_SALES, BEER_SALES_WITH_PREDICTORS, etc)
    You can do joins on these tables but they may not be the most fun.

BIRT Sample Data

This data is provided as a sample to help users learn another tool.  The data is about Classic Cars company and has about 7 tables.  When I downloaded the data, there was a sample MS Access database that I was able to extract into SAS EG easily.  I like this data because it provides the ER diagram and the help file explains some of the trends and problem areas for the data.  It really helps you learn how to over come situations that you would see in real data tables.  For instance, one issue is the way to work with the customer payments.  How much does the customer owe the company today?

Microsoft SQL/Access

You can find samples and free data at the Microsoft site.  Obviously this data is intended for their product lines and may require some brute force to import into SAS Enterprise Guide.  There is a sample called Adventure Works.  Warning … it has a lot of tables and will be some work to import.  It does supply some SQL code but it looked like it might be easier to just use the SAS Import Wizard.

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

 


Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
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 been using SAS since 2001. Contact her for assistance with your next project.
Spread the love

Tags: , ,