BookmarkSubscribeRSS Feed

How to import, export Excel and SAS data

Started ‎10-08-2021 by
Modified ‎06-13-2024 by
Views 9,686

In these two YouTube tutorials, SAS' @KathyKiraly addresses two popular questions asked here in the communities, around importing and exporting data. She reveals two ways to do each: through the LIBNAME statement and PROC IMPORT or PROC EXPORT.

 

 

Comments

This video helped. I was trying to figure out the difference between "libref", "libname", "data set" and "data step". Making the libname "X" was so simple, I was able to understand. 

 

It is hard to recognize what a data step is in the book when there are so many types of data steps, so I will have to just keep watching examples.

 

Until recently, I had the impression that I placed "libref" in the libname statement. Often the error message would come back as to paraphrase "libref doesn't exist", though it never told me what that meant. Now that I've got that misunderstanding behind me, I hope SAS won't be as confusing.  

 

Edit: I forgot to mention. I only watched half of the video, because I didn't want the new information in the video to confuse me, but as I go further in the SAS program, I'll get back to the rest. 

Contributors
Version history
Last update:
‎06-13-2024 02:18 PM
Updated by:

Viya Copilot Motion Graphic.gifViya Copilot Motion Graphic

Ready to see what SAS Viya Copilot can do?

Visit the Tips & Tricks page for setup guidance, demos, and practical examples that show how Copilot supports your workflows.

Get Started →

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