How to read Excel spreadsheets with SAS University Edition

This blog post teaches you how to import an Excel spreadsheet into the free SAS University Edition, so you can further analyze and graph the data. First, you need to create a folder on your local computer (such as C:\\SASUniversityEdition\\myfolders\\ ), and then then set that up as a Shared […]

Post a Comment

Why learn SAS instead of Excel? ... Medicare data

Would you like to analyze the 9 million lines of Medicare payment data that was recently made public? You'll need lots of luck if you're planning to use Excel ... whereas this is the kind of thing SAS was built for! Their data download page warns that trying to import the raw […]

Post a Comment

Do you use SAS for analytics and Excel for graphs?

Do you use SAS for analytics and Microsoft Excel for graphs? Why not use SAS for your graphs too?!?  Then you could completely automate the entire process in one SAS program, with no manual steps! A lot of people use Excel to create their graphs because "it's what they know."  What if somebody […]

Post a Comment

How SAS engines can read a range of data in Excel

Japan has a superfast train called the Shinkansen. The first I heard of it was when my sister visited Japan on a scholarship. Engine-awestruck, we wanted a ride, but weren’t able to get to Japan. Nor, did we know the language. (With over 5000 kanjis, it took my sister 3 […]

Post a Comment