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.
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.
Latest posts by Tricia Aanderud (see all)
- SAS VA: Is Location just a Distracting Character in Your Dataviz? - August 24, 2015
- Do You KISS Your Line Charts? - August 5, 2015
- How Not Knowing Pie Charts Makes You a #DataViz Rookie - May 7, 2015
- 6 Tips for Data Visualization from a Floral Designer - March 26, 2015
- SAS Coding: Use Flowcharts to Learn Inherited SAS Code - March 2, 2015