16 ways to easily get data from SAS format into Excel format to help you become more effective in your job

“Hooking up SAS and Excel” presented by Colin Harris – Knoware Technical Director

youtubeColin’s popular presentation on 16 ways to transfer information from SAS to Excel is now available on Knoware’s new  www.youtube.com channel.

This series of 13 videos enable you to learn at your own pace, and to go back and look again at the techniques you prefer to use.

The videos use a Powerpoint style of presentation so that you can pause the video. Colin’s talk provides a detailed description for your information.

Please contact us if you wish to learn more or have questions.

About this video series on moving data from SAS to Excel – Colin introduces his presentation (6 min 21 sec)

Video 1 – EG export and import (6 min 20 sec)

Video 2 – EG export as a project step (5 min 28 sec)

Video 3 – DMS export and import wizards (6 min 14 sec)

Video 4 –  ODS CSV, XML, HTML, MS Office2000 (14 min 17 sec)

Video 5 – ODS ExcelXP Tagset (12 min 20 sec)

Video 6 – Proc Export and Import (10 min 1 sec)

Video 7 – SAS Excel libname engine (12 min 13 sec)

Video 8 – Third-party Control Code (4 min 04 sec)

Video 9 – Using AMO (9 min 13 sec)

Video 10 – What to use OLEDB or ODBC ?  (5 min 35 sec)

Video 11 – Using DDE (5 min 20 sec)

Video 12 – Summary by Colin Harris (5 min 27 sec)