I am using SAS OnDemand for Academics to run my SAS code. Recently, for my school project, I was given a .sas7bdat file to work on. I downloaded it from google classroom, and then uploaded it to my home directory. However, each time I open it, sas studio goes into an infinite loading sign saying: "Opening a table". I managed to stop the process by reloading SAS studio, however, the problem is that I need that data set to continue my project, and each and every time I try to run code that involves accessing this file, an infinite "Running Code" sign shows up. Why is SAS not able to open and use my sas7bdat file, and what should I do to resolve this error?
stop the process.
Check the log after running ONLY the line
libname earth "/home/userid/sasuser.v94";
see if the library is successfully created.
Assuming that the library is succesful
try running
Proc contents data=earth.earthdayfinal;
run;
If that doesn't have a problem try
data earth.earthfinal; set earth.earthdayfinal; cleanStr = translate("Moonbeam Café","e","é"); if donamt = 375 then Sponsor = cleanStr; drop cleanStr; run;
I am wondering you may have accidently done something to your Work library which is where your output would currently go.
You might try expanding you LIBRARIES tab immediately after running the LIBNAME statement and nothing else. If you are either not creating the library or having an issue with that you could be getting odd behavior.
1) show the code used
2) is someone provided the file there could be an issue with operating system file format differences.
libname earth "/home/userid/sasuser.v94"; data earthfinal; set earth.earthdayfinal; cleanStr = translate("Moonbeam Café","e","é"); if donamt = 375 then Sponsor = cleanStr; drop cleanStr; run; proc print data = earthfinal; run;
Sorry for that, here is my code. If I run the libname statement only, then it runs properly, and the library is created. But as soon as I do the data step, it goes into an infinite run loop, like:
Its been like that for like 2 hours now, please help :'(
stop the process.
Check the log after running ONLY the line
libname earth "/home/userid/sasuser.v94";
see if the library is successfully created.
Assuming that the library is succesful
try running
Proc contents data=earth.earthdayfinal;
run;
If that doesn't have a problem try
data earth.earthfinal; set earth.earthdayfinal; cleanStr = translate("Moonbeam Café","e","é"); if donamt = 375 then Sponsor = cleanStr; drop cleanStr; run;
I am wondering you may have accidently done something to your Work library which is where your output would currently go.
You might try expanding you LIBRARIES tab immediately after running the LIBNAME statement and nothing else. If you are either not creating the library or having an issue with that you could be getting odd behavior.
Thank you! It worked for me 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.