Data Intelligence, Business Analytics
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 to create a stored process that can return a HTML table. I do not want to describe the process of registering a stored process here, but it can be done in several methods [See Angela's example in this You Tube video: Create a Stored Process in One Little Minute.]
This is the stored process program that I created. It’s just a simple query of the Class dataset from the SAS HELP sample data:
Read entire article at BI Notes.
Comments are closed for this blog post