AnalyticBridge

Data Intelligence, Business Analytics

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.

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.

Top Content

1	Why is it so hard to count this way?
2	Yelp won't hire unemployed data scientists
3	Normalized odds-ratio
4	Reverse clustering for tactical warfare
5	Time Period for Analytical Positions Recruitment.
6	Seven Questions on Adopting Analytics Culture
7	Outliers : Capping rule
8	Correlation and R-Squared for Big Data
9	Cross-validation in R: a do-it-yourself and a black box approach
10	Do You Have What It Takes To Be a Data Scientist?