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.

The following two tabs change content below.
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC. 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: , ,

4 Comments »