BookmarkSubscribeRSS Feed

OCIESUG Meeting: Integrating SAS and Microsoft Excel (Jan 2021)

Started ‎01-29-2021 by
Modified ‎01-29-2021 by
Views 3,672

The Orange County Inland Empire SAS Users Group (OCIESUG) sponsored this webinar on Jan. 27, 2021. The meeting featured a highly asked-for topic and SAS and Microsoft Excel, presented by Vince DelGobbo ( @Vince_SAS ).  Here is the on-demand recording of that meeting, including links to the slides and code so that you can put the techniques into practice.


Integrating SAS and Microsoft Excel: Exploring the Many Options Available to You

This presentation explains different techniques available to you when importing and exporting SAS and Microsoft Excel data.   You learn how to import Excel data into SAS using the IMPORT procedure, the SAS DATA step, SAS Enterprise Guide, and other methods.   Exporting data and analytical results from SAS to Excel is performed using the EXPORT procedure, the SAS DATA step, SAS Enterprise Guide, the SAS Output Delivery System (ODS), and other tools.   The material is appropriate for all skill levels, and the techniques work with various versions of SAS software running on the Windows, UNIX (including Linux), and z/OS operating systems.   Some techniques require only Base SAS and others require SAS/ACCESS Interface to PC Files.


Learn more and practice

Version history
Last update:
‎01-29-2021 08:42 AM
Updated by:



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags