BookmarkSubscribeRSS Feed

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

Started ‎01-29-2021 by
Modified ‎01-29-2021 by
Views 4,313

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:

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

SAS AI and Machine Learning Courses

The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.

Get started

Article Tags