BookmarkSubscribeRSS Feed
JessLund
Obsidian | Level 7

Can you export SAS data sets from SAS Applications like SAS Data Studio in excel format?

2 REPLIES 2
SASKiwi
PROC Star

I'm assuming you mean SAS Studio, the web-based SAS program development interface. I'm pretty sure there is a task for that but you could also PROC EXPORT or the XLSX LIBNAME engine.

Cynthia_sas
SAS Super FREQ
Hi, SAS Data Studio is one of the SAS Viya applications. If you are using our free SAS Viya for Learners platform, then you cannot upload, download, import, export on the server at the present time. For your own SAS Viya installation at your company, you would want to check with your SAS Administrator to find out what features you have permission to use. Importing, exporting, uploading and downloading all will need write access on the server which you'll need to make sure that you have.
If you mean SAS Studio on the SAS OnDemand forAcademics platform, you can export to an Excel format file into your /home folder (this is the Files (Home) top folder), then you can download from that folder to your local machine. With SAS OnDemand for Academics, SAS Studio cannot write directly to your local machine, so you'll need to do the export first and then the download.
Cynthia

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 369 views
  • 1 like
  • 3 in conversation