BookmarkSubscribeRSS Feed
SAPPER
Calcite | Level 5

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

4 REPLIES 4
Tom
Super User Tom
Super User

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.

SAPPER
Calcite | Level 5

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?

Tom
Super User Tom
Super User

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.

SAPPER
Calcite | Level 5

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

sas-innovate-2024.png

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.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

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
  • 4 replies
  • 1895 views
  • 0 likes
  • 2 in conversation