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.
This paper is available for downlad at:
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/2991-2019.pdf
Download the "DelGobbo_Excel_2019_HOW.zip" file and follow the instructions in the "ReadMe.txt" file available in the ZIP archive.
If you do not want to use the ZIP archive then you can access the individual files in the Files folder.