Knoware Breakfast Repeat Briefing: Hooking up SAS and Excel and ditching DDE

Date: 16th April 2013

Location: Wellington

Due to popular demand we re-ran last months seminar presented by Colin Harris. If you would like to arrange for an special in-house briefing for your organisation, then please contact Colin Harris or Clare Somerville on info@knoware.co.nz or phone 04 499 9246.

It’s a very common need to get information from SAS into Excel, and vice-versa. There are a number of ways to do this, each with its advantages and disadvantages. This session gave an overview of 10 different techniques, and the pros and cons of each. It ranged from simply creating a basic Excel spreadsheet through to updating a pre-formatted spreadsheet, including pivot tables and charts. A number of techniques require “base SAS” only, and others need additional products. The techniques include:

  • Import and Export wizards
  • ODS CSV, XML and HTML methods
  • ODS ExcelXP tagset
  • Proc Export and Import
  • SAS Excel libname engine
  • Add-in to Microsoft Office (AMO)
  • OLEDB
  • ODBC
  • DDE (and why it should be replaced)

Listen to and view a series of videos of Colin Harris’s PowerPoint presentations describing each technique

Or you can review the full Powerpoint presentation without the commentary (PowerPoint 116 pages, PDF format, 6.29MB)

Back to Events
Knoware Breakfast Repeat Briefing: Hooking up SAS and Excel and ditching DDE