Create Your Own Sample Data for SAS BI
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.
- Output as many rows as you like to several different file types (XLS, CSV, and even emulate Oracle tables)
- Load tables that others have created. As with anything free, some are better than others.
- 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.
You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.
Latest posts by Tricia Aanderud (see all)
- SAS Add-In for MS Office: Abe Lincoln Sends Glee in a Snowstorm - February 18, 2014
- #SASGF14: You’re Invited to a TweetUp! - February 10, 2014
- SAS Stored Process Dealing with Disappearing Results - January 31, 2014
- More SAS Stored Process Sleight of Hand Tricks - January 29, 2014
- Little Known Secrets from SAS Stored Process Magicians - January 26, 2014