BookmarkSubscribeRSS Feed
Calcite | Level 5

Hi fellow,

I've been looking on the web for the entire day about how to use .sas7bdat sas tables with sas studio university edition. I've tried doing the libname thing and it dosent work. However, I keep reading everywhere that I need to upload it onto the server in order to read it in because it can't read it off the local machine. I have no idea how to do this and its starting to infuriate me.

Super User Tom
Super User

SAS UE is no longer supported.  You can use SAS ODA which is also using the SAS/Studio interface but instead of running SAS in a virtual machine on your computer it runs SAS on machine that SAS hosts.


To upload a file using the SAS/Studio interface you just need to click on the folder where you want to write the file and click on the UPLOAD icon.  You can then browse to the file you want to upload and select it.



Once you have a sas7bdat file on the machine where SAS is running you can either use the file directly by referencing it using a quoted physical name. Or create a libref pointing to the folder where it lives and using a two level name.


So if you uploaded a file name mydata.sas7bdat to your home directory you could use either of these programs to see the content information of the dataset.

proc contents data="~/mydata.sas7bdat"; run;

libname mylib "~";
proc contents data=mylib.mydata; run;

Remember that the SAS session you are using with ODA is running on UNIX.  So the name of file that is the SAS dataset must be in all lowercase letters.  So not MyData.sas7bdat or mydata.SAS7BDAT, but only mydata.sas7bdat.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2 in conversation