SAS Enterprise Guide: Import the Excel Spreadsheet – Easy Peasy
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” 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.
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 Your Excel Spreadsheet
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.