Home » Coding & Data

Create Your Own Sample Data for SAS BI

Submitted by on October 12, 2011 – 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.

Attending SESUG 2015?

If you are planning to attend SESUG 2015 in beautiful Savannah, Georgia on Sept 29 then join me for my talk about data visualization "How to be the MacGyver of Data Visualization"! I'll show you some cool ways to visualize data with SAS Visual Analytics as well as some traps to avoid.

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