Subscribe to DSC Newsletter

Tricia Aanderud's Blog – February 2013 Archive (1)

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…


Added by Tricia Aanderud on February 21, 2013 at 5:30am — No Comments

On Data Science Central

© 2021   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service