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
