BookmarkSubscribeRSS Feed
FraukevdRijt
Calcite | Level 5

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;

 

abc.PNG

6 REPLIES 6
ballardw
Super User

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?

 

 

 

FraukevdRijt
Calcite | Level 5


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? 

pop.PNG

 

 

 

Tom
Super User Tom
Super User

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?

 

 

 

FraukevdRijt
Calcite | Level 5

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. 

Tom
Super User Tom
Super User

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?

 

ballardw
Super User

@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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 576 views
  • 0 likes
  • 3 in conversation