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 » Coding & Data

Create Your Own Sample Data for SAS BI

Submitted by on 2011-10-12 – 6:00 AM 4 Comments

In a previous post I suggested some places to find sample data that you could import into the SAS BI for use in various learning projects.  I found the Identity Generator site that allows you to create and download test data. Plus it’s my favorite price,  free!  This is a low tech approach but for what I am usually doing, it would work great.   There are several site features that I really liked.

  1. Output as many rows as you like to several different file types (XLS, CSV, and even emulate Oracle tables)
  2. Load tables that others have created.  As with anything free, some are better than others.
  3. Fields are only limited by your imagination.  Suggest names when you are creating a custom field (shown in the example).

After creating your data, just press the green Generate button and ta-dah!  For the company name data generated in the example, my idea is to pull the data into SAS Enterprise Guide and then concatenate the three company name fields to have a somewhat wacky list of company names (Askvig Redla Limited, Clarke Wynn Calition, and Elvin Shinobu Conglomerate).



Generate a Sample Customer List

There was an existing list called SampleBasic that setup a Patient list for an Oracle database.  The first image shows how the table is generated and the following image shows the result.  If you create some data with this tool, I’d love to hear about it.

Sample Data Generated



















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

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: , ,


  • Tod Almengor says:

    Of course, what a magnificent blog and enlightening posts, I will bookmark your website.All the Best!

  • Anonymous says:

    Hey i must say this was amazing post keep up the good work

  • Brijendra says:

    Hi Tricia, Thanks alot for sharing this valuable site with us.
    Thanks & Regards

    • Tricia says:

      Thanks for the kind comments Brijendra. Let me know if you have any SAS BI related questions.