Subscribe to Dr. Granville's Weekly Digest

View a SAS table in Excel using a Web Query and a Stored Process

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:

stored process ms excel

Read entire article at BI Notes.

Views: 249

Comments are closed for this blog post

© 2014   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC

Badges  |  Report an Issue  |  Terms of Service