Hello,
We are having a problem (not limited to one user ) with creating permanent datasets using EG.
We could still create permanent datasets using PC SAS and doing a RSubmit or using Putty to submit code in a non interactive mode.
The issue pops up when we start to use EG.
Here is a simple code that replicates the error:
libname test '/sas/products/dev ';
data test.ABCD;
x=1;
run;
ERROR: Rename of temporary member for TEST.ABCD.DATA failed.
Basically the file gets created but has .lck extension next to it and the rename from ABCD.sas7bdat.lck to ABCD.sas7bdat fails..
We have checked the permissions on unix and at the file system and they seem to be fine as the user is able to create the datasets using Remote submission of code and Non interactive mode.
The space on the file system is also ample .
Can someone point if there is anything else that we need forgot to check.
The whole thing started after a planned reboot of the SAS server.
Here are some of the threads that we have gone through, but didn't relate to our problem.
http://support.sas.com/kb/30/468.html
Thanks
SAPPER
Sounds like a problem we had on an old Novell network. They had granted us Write and Create permission, but we did not have permission to Delete files.
When SAS creates a dataset it first creates it with a different name and then renames it.
When SAS recreates a dataset it waits till it has created the file with the different name first before it deletes the original and then renames the file it just created.
Thanks Tom,for the reply.
We are able to create datasets using PC SAS but not with EG.
Is there something different that's going on the server when we use EG rather than PC/SAS?
It normally runs with a different account, so that account might have different permissions than the individual users.
I have no idea about that type of administrative detail, but SAS support can definitely help.
Can some SAS Administrative gurus comment on which accounts (if present by default on the SAS server) are used by EG to write/delete/rename the datasets and how to view the permissions associated with those accounts , so that I could forward that information to our support guys here.
Thanks
SAPPER
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.