topic opening documents when starting up SAS in SAS Programming

opening documents when starting up SAS

FraukevdRijt — Fri, 05 Apr 2019 09:28:23 GMT

Dear,

When I try to save permanent SAS documents in my SAS library. I can't open them anymore after that I close down the program. I keep getting the message like in the photo. Can somebody help me?

I try to save documents in sasuser with this syntax.

/* data van work library in sasuser zetten*/
data sasuser.pisacog2003bel; set work.pisacog2003bel;
run;

Re: opening documents when starting up SAS

ballardw — Fri, 05 Apr 2019 15:03:23 GMT

It is kind of late after the fact. Normally I would suggest posting the LOG of the program that created the data set as usually the types of things that result in datasets you can't open is some problem with the creation. I don't see any reason for the shown code to have a problem though.

If you are working on windows the physical location for your SAS user library is likely something similar to:

C:\Users\<your id here>\Documents\My SAS Files\9.4

Use the Windows Explorer to go to that location and see if the file is there or has any problems.

If you right click on the data set in the SAS explorer and click on the Properties for the set what does it show? Can you get properties such as number of observations?

Re: opening documents when starting up SAS

Tom — Fri, 05 Apr 2019 16:18:19 GMT

Can you run PROC CONTENTS on the dataset?

Does that dataset have user defined formats attached to any of the variables?

What happens if you set the option NOFMTERROR?

Re: opening documents when starting up SAS

FraukevdRijt — Fri, 05 Apr 2019 17:11:02 GMT

NOTE: There were 5059 observations read from the data set WORK.PISASTU2003VLA.
NOTE: The data set SASUSER.PISASTU2003VLA has 5059 observations and 404 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.04 seconds

this is the end of the log I get. So it should be right...

The picture is what I see by properties, so this is also right I think, the problem is that when I want to close down SAS now and start up again, the dataset isn't permanent and then I get this error. So, do you know why the dataset isn't made permanent?

Re: opening documents when starting up SAS

FraukevdRijt — Fri, 05 Apr 2019 17:13:20 GMT

Yes I can run PROC CONTENTS and this looks good, I see all the variables.

But when I close down SAS and start up again I get the error sign...

So the dataset isn't made permanent I think.

Re: opening documents when starting up SAS

Tom — Fri, 05 Apr 2019 17:30:34 GMT

Do any of the variable have permanently attached a user defined format?

Did you set the NOFMTERR option before trying to open the dataset?

Did you try running a PROC against the dataset?

Re: opening documents when starting up SAS

ballardw — Fri, 05 Apr 2019 20:19:42 GMT

@FraukevdRijt wrote:

Yes I can run PROC CONTENTS and this looks good, I see all the variables.

But when I close down SAS and start up again I get the error sign...

So the dataset isn't made I think.

Did you run proc contents before the shut down OR after restarting SAS? I am interested in what you get after restarting SAS.

Show the log if you get any errors or problems with proc contents.

You may also want to clear the log and then submit this code:

Proc Options; 
run;

Then copy the log results and paste into a code box opened using the forum's {I} icon.

It is best to always include the code with the log results and paste the entire thing into a code box.