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 Company Names Generate a Sample Customer List There was an […]
Tag: data
Create, Access, and View Data – All the tools you need!
SAS EBI is comprised of several applications. Here is a quick overview: Make Data SAS OLAP Cube Studio Build OLAP cube using SAS datasets. SAS Information Map Studio Build information maps from SAS datasets and OLAP cubes. SAS Enterprise Guide Connect to SAS datasets, RDBMS, and even Excel spreadsheets SAS Add-In for Microsoft Office Possible to create data in MS Excel that you can save to the server and then use in other BI Tools. This would be an option for smaller datasets that are updated infrequently and not centrally stored, for instance, an department organization structure. Use Data Web Report Studio Create reports from OLAP Cubes, Info Maps, or SAS datasets. SAS Enterprise Guide Create reports and more from OLAP Cubes, Info Maps, or SAS datasets. Also create reports that can be shared as a stored process for the other SAS SAS Add-In for Microsoft Office In MS Excel – Create reports from OLAP Cubes, information maps, or SAS datasets. Mix SAS data with the data from Excel spreadsheets. In MS Office/PowerPoint – create reports from cubes, information maps, or datasets. Not as much flexibility as with MS Excel, but you can easily create report that you can share […]
Sample Data Sources
As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore. Here is a list of free sources that I have found that can help as you learn and want to challenge yourself. Simple Data Tables Here are some sources for simple data tables. These are datasets with all of the data contained in one table and do not need to join to anything else. SASHELP This listing of data may be most familiar to BASE SAS users. This library has several ready made data sets (i.e. SHOES, CLASS, and CARS). If you do not see a SASHELP library in your list, then ask your SAS Administrator to add it. SAS Enterprise Guide Data EG 4.3 shipped with some fun ready-made simple datasets: Bullets, Drugs, and TotArrests. [Hmmm …. ] This data was located in this path on my EG 4.3 installation: C:\Program Files\SAS\EnterpriseGuide\4.3\Sample\Data DATA.GOV http://www.data.gov/ has a ton of simple raw data tables on a variety of topics: earthquake activity, income data by county for 2007, and unemployment statistics. It is actually just fun to poke around to see what is available. This site also has links to other […]
Progress reading SAS sas7bdat files (natively) in R
This post describes some preliminary results from a compatibility study of the SAS sas7bdat file format. The most current results stored in a github repository here: sas7bdat The ultimate goal is a native solution to the incompatibility between open-source statistical software (e.g. R) and sas7bdat database files. Demonstration There has been significant progress in interpreting […]