SAS Tutorial | How to import data from Excel to SAS

In this SAS How To Tutorial, Kathy Kiraly shows two ways to import data from Excel to SAS. The first approach uses the LIBNAME statement, and Kathy shares the power of the DATA step and other procedures. The second approach leverages PROC IMPORT in SAS.

To import Excel data to SAS using these approaches, note that you must be running SAS version 9.04.01M2 or higher. Not 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.

Chapters
0:00 – LIBNAME statement example
8:42 – PROC IMPORT 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...
◉ Learn Base SAS - https://support.sas.com/en/software/b...
◉ Free SAS Programming 1: Essentials course - https://support.sas.com/edu/schedules...
◉ Book: Exchanging Data between SAS and Microsoft Excel - https://www.sas.com/store/books/categ...


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 ► https://www.sas.com
SAS Customer Support ► https://support.sas.com
SAS Communities ► https://communities.sas.com
SAS Analytics Explorers ► https://explorers.sas.com
Facebook ► Facebook: SASsoftware
Twitter ► Twitter: SASsoftware
LinkedIn ► LinkedIn: sas
Blogs ► https://blogs.sas.com
RSS ► https://www.sas.com/rss

• #science_technology
• #sas_tutorial
• #import_data
• #import_data_from_excel_to_sas
• #excel_to_sas
• #sas_how_to_tutorial
• #libname
• #libname_statement
• #data_step
• #proc_import
• #sas
• #learn_sas
• #sas_tutorials
• #sas_tutorial_for_beginners
• #sas_for_beginners
• #sas_libname
• #sas_libname_statement
• #sas_data_step
• #sas_proc_import
• #read_data_from_excel_in_sas
• #excel_in_sas
• #import_excel_to_sas
• #proc_import_in_sas
• #how_to_import_excel_to_sas
• #sas_import