One SAS Enterprise Guide feature I particularly like is the ability to import Microsoft Excel data quickly and easily. SAS offers many ways to work with Excel spreadsheets but often I find I just want to extract data from Excel and get on with my job.
Tip – Click on any picture to see a larger image!
Use a “Known Good” Spreadsheet the First Time
If you are trying this process for the first time, use a “known good” or simple spreadsheet so if any issues arise you can at least eliminate the data as the cause. When this process fails, I generally find that the spreadsheet has something odd going on, such as pasted text, etc. SAS Enterprise Guide has some sample spreadsheets available, which I use in this example. [Tip: Here’s how to deal with odd spreadsheet data.]
The SupplyInfo.xls spreadsheet is available in the SAS Enterprise Guide Sample data sub-directory. It has two sheets: Suppliers and Shippers. Let’s import the Suppliers spreadsheet for some quick analysis. Here is the location of my sample files. [Read Create Your Own Sample Data for SAS BI for ideas about where other sample data lives.]
Import Excel Spreadsheet Data into SAS
I’m using SAS Enterprise Guide 5.1; as far as I can tell the wizard has not changed much from earlier releases so you should be able to follow along.
Viewing the Results
After the import completes you will have a fresh dataset to use for analysis.
Modifying the Import
If you don’t like how the data appears, you can ticker with the results. The Modify Task button re-starts the Data Import wizard. You can also right-click the Import Data icon to make changes.
If you later add more rows to the spreadsheet, just Run the Process Flow again. You can re-import the spreadsheet a thousand times if you want to spend your day doing that. 😉
Never miss a BI Notes post!
Click here for free subscription. Once you subscribe you'll be asked to confirm your subscription through your email account. You email address is kept private and you can unsubscribe anytime.