Hooking up SAS and Excel – 1/2 Day Seminar
This Seminar is designed for you if..
you need to make use of an interface between SAS and Excel to deliver reports and data analysis to your users. Find out how to use the 12 most useful techniques to interface SAS and Excel and when to use them.
Date:
This course is run according to demand
– please contact us to express your interest
Cost:
Please contact our team for the latest pricing
Start/Finish Times:
8:45am Registration, Seminar 9:00am to 12:30pm
Presenter:
Dave Shea – Knoware Consultant and Trainer
Venue:
To be advised for public courses, or can be held in your offices for in-house seminar.
Note:
Please bring your own device (BYOD) or paper for note taking
What is this Seminar all about?
Hooking up SAS and Excel
Ensure you know the best and latest SAS and Excel integration techniques to:
- Get the best results
- Save you time
Interfacing between SAS and Excel is one of the most common things that SAS analysts or developers need to do. There are over 20 different ways to interface SAS and Excel, either to read Excel data into SAS or to produce or update Excel spreadsheets from SAS.
New techniques are being added all the time, like the recent impressive ODS Excel option.
Make sure you are aware of all main techniques, to be able to use the most appropriate approach for your business needs. Get a comprehensive overview of the key techniques, and see them in action, in this information packed half-day session.
This seminar will give an overview of 12 different techniques, and the pros and cons of each. It will range from simply creating a basic Excel spreadsheet through to updating a pre-formatted spreadsheet, including pivot tables and charts.
The main techniques covered include:
- Import and export wizards
- Output delivery System (ODS)
- ODS CSV, XML, HTML and Office2K methods
- ODS ExcelXP tagset
- ODS Excel (new and excellent!)
- PROC EXPORT and IMPORT
- SAS Excel Libname engine
- SAS Add-in to Microsoft Office (AMO)
Some other techniques will be covered briefly, including:
- Third-party control code – .Net, VBA or Java
- OLEDB, ODBC, DDE (and why it should be replaced!)
A number of techniques require base SAS only, and others need additional products, for example SAS/Access to PC File Formats.
Target Audience
More Services
More Training to Enhance Your Skills and Career
SAS Analytics
We help you make the best use of your data by using analytics and reporting techniques to gain insights. You can use these insights for your planning, and “day to day” operations decision making.
Information & Data Management
Knoware’s Information and Data Management Services can help you manage your information and data environments effectively, efficiently and with confidence and provide an excellent basis for running a sound technical environment
SAS Expertise
We provide expertise across all aspects of SAS from analysts/developers through to SAS modernisation and upgrades and platform administration
