In this SAS How To Tutorial, Kathy Kiraly shows you two ways to export SAS data to Excel. The first approach uses the LIBNAME statement, and Kathy talks about the power of the DATA step and other procedures. The second approach leverages PROC EXPORT in SAS.

In order to export SAS data to Excel using these approaches, note that you must be running SAS version 9.04.01M2 or higher. Now sure which version you're on? Kathy shows you how to check. Both methods also require SAS/ACCESS software for integrating SAS and third-party databases.

Content Outline 00:15 – LIBNAME statement example 12:28 – PROC EXPORT example

Related Content Here's the data set Kathy uses – https://github.com/sascommunities/sas... SASGF Paper: Integrating SAS and Microsoft Excel - https://www.sas.com/content/dam/SAS/s... SASGF Paper: Integrating SAS and Microsoft Excel - https://www.sas.com/content/dam/SAS/s... Book: Exchanging Data between SAS and Microsoft Excel - https://www.sas.com/store/books/categ... Book: Exchanging Data from SAS to Excel: The ODS Excel Destination - https://www.sas.com/store/books/categ... SAS Programming Community - https://communities.sas.com/t5/SAS-Pr...

SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS https://www.youtube.com/SASUsers?sub_...

ABOUT SAS SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

CONNECT WITH SAS SAS ► http://www.sas.com SAS Customer Support ► http://support.sas.com SAS Communities ► http://communities.sas.com Facebook ► https://www.facebook.com/SASsoftware Twitter ► https://www.twitter.com/SASsoftware LinkedIn ► http://www.linkedin.com/company/sas Blogs ► http://blogs.sas.com RSS ►http://www.sas.com/rss