topic Re: Stuck on opening a table but don't understand fix in New SAS User

Stuck on opening a table but don't understand fix

monyakjt — Sat, 04 Jan 2025 20:11:13 GMT

Looking for help. I am using SAS ondemand for Academics. I clicked on a sas data set I uploaded. Now it just reads "Opening a table" and has been doing this for about 24 hours. I found that others have experienced this and the posts mention shutting down the VM. I don't understand this. I am not using any special software to access Sas ondemand (as far as I know anyway); just the browser. Appreciate any help. Thanks,

Re: Stuck on opening a table but don't understand fix

Tom — Sun, 05 Jan 2025 01:12:53 GMT

How large was the dataset you uploaded?

Was it a SAS dataset? Or do you mean some other type of file?

Instead oif trying to open the file interactively try running some code to look at the file and just print PART of it.

For example run PROC CONTENTS on the SAS dataset to see what variables it has and how many observations.

Soi if you uploaded a file name memname.sas7bdat then you migth run something like this:

libname mylib '...path of the directory where you save the file...';
proc contents data=mylib.memname;
run;

Or run PROC PRINT for just the first few observations.

proc print data=mylib.memname(obs=3);
run;

If it is just a TEXT file, such as a CSV file, then run a data step to see what is in it. For example a program like this will dump the first 5 lines from the file to the SAS log.

data _null_;
  infile 'fully qualified name of file'  obs=5;
  input;
  list;
run;

Re: Stuck on opening a table but don't understand fix

monyakjt — Tue, 07 Jan 2025 15:14:29 GMT

Thanks for the reply.

Your suggestion is what I should have done, I suppose. But the problem is I can't even execute any SAS code now, because the system is stuck. Before it was stuck on opening a table. Now, I just tried it again, and it seems to be stuck just on logging in. It just says "initializing" and is hanging.

Re: Stuck on opening a table but don't understand fix

SASKiwi — Wed, 08 Jan 2025 02:54:18 GMT

I don't know if this will help, but I suggest you delete all browsing history in your web browser, reboot your PC and then try signing in again. The SODA FAQ provides some additional things to try.

Re: Stuck on opening a table but don't understand fix

alexjordan — Wed, 08 Jan 2025 05:43:01 GMT

I have tried this one once I faced this issue.

Re: Stuck on opening a table but don't understand fix

monyakjt — Sun, 12 Jan 2025 20:37:51 GMT

I tried what you suggested. It did allow me to get back into SAS studio (before it got stuck on "initializing" while signing in). But it is still stuck on "opening a table". It is over a week, now. I would have thought this process would have stopped on its own at some point. Any other ideas? Appreciate any help, thanks.

Re: Stuck on opening a table but don't understand fix

SASKiwi — Sun, 12 Jan 2025 21:08:33 GMT

I'd suggest trying a different web browser to see if that helps. What one are you using now?

Re: Stuck on opening a table but don't understand fix

monyakjt — Mon, 20 Jan 2025 16:54:05 GMT

I was using the Chrome browser. I tried Edge, but it gave the same thing. I contacted SAS support. They suggested deleting cookies and cache. I tried that, but it did not work.

thanks,

Re: Stuck on opening a table but don't understand fix

Tom — Mon, 20 Jan 2025 23:22:17 GMT

What do you mean by "opening a table"?

Are you able to run code?

Try running something simple first.

proc print data=sashelp.class;
run;