BookmarkSubscribeRSS Feed

SAS OnDemand for Academics Tip: Getting Excel Data into SAS Studio

Started ‎08-14-2017 by
Modified ‎08-04-2021 by
Views 2,246

Question

How do I upload Excel data to SAS Studio if I don’t want to use default methods?

Answer

If you don't want to use SAS Studio's defaults, which write data to the working directory, try this option from @DrAnnmaria, posted on her blog. In her article, Getting Excel Data into SAS Studio: Beyond the Defaults, she offers a few simple steps for when you want your Excel data formatted a certain way as a SAS data set.

Version history
Last update:
‎08-04-2021 01:18 PM
Updated by:
Contributors

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags