Guest Post by Stig Eide

Stig Eide showed me a trick for using the Excel web query to look at SAS data. Very clever trick!

Want to view a SAS table in Excel but you don't have the Add-In for Microsoft Office installed? This post describes an alternative method. Excel has a nice feature where you are allowed to query a web page for data. I will describe how you can set up the query against a stored process, and how to pass parameters.

First, you need…