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: 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!

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
  • 534 views
  • 1 like
  • 3 in conversation