Prev: Retain -- Data Structure
Next: remove last 3 characters from a string
From: UKR on 14 May 2010 16:02
Hi, I am getting an error like:

ERROR: You cannot open WORK._CONVERTDATA.DATA for output access with
member-level control because WORK._CONVERTDATA.DATA is in use by you
in resource environment DMS Process.

What is the nature of this error and why I am getting it? How to get
rid of this error? I suppose it is related to some system options. I
am trying to close my data sets with RC function, but this does not
help.
Why SAS is so undocumented and sometimes _very_ stupid. I read tons of
information already and get everything except what I need.

Thanks!

If someone can help. (Hopefully SAS institute is not on vacation.)

From: Lou on 14 May 2010 20:00

"UKR" <nlkpch(a)gmail.com> wrote in message
news:5afe5f67-c864-4b41-a92d-bfb5adaf07c2(a)e21g2000vbl.googlegroups.com...
> Hi, I am getting an error like:
>
> ERROR: You cannot open WORK._CONVERTDATA.DATA for output access with
> member-level control because WORK._CONVERTDATA.DATA is in use by you
> in resource environment DMS Process.
>
> What is the nature of this error and why I am getting it?

It looks to me like you're trying to write to a dataset in the WORK library,
but you can't because you already have the dataset open in some other way.
Possibly you're displaying it in something like VIEWTABLE or FSVIEW, or
maybe you've executed a segment of code that opens the dataset but haven't
executed the part that closes it.

DMS is Display Manager System, which indicates you're in an interactive
session. I don't know what "Process" refers to.


> How to get rid of this error?

Close the dataset before attempting to open it again. Or terminate whatever
process has it open.

>I suppose it is related to some system options.

I doubt it.

> I am trying to close my data sets with RC function

I've never heard of the RC function, and I can't find it in the help for my
system (version 9.1.3 on Windows). RC (short for Return Code) is often used
in the docmentation for directory, file, and dataset functions as a variable
that receives a numeric code relating to the success or failure of the
function's operation - a value of zero generally indicates the function
executed succesfully. Maybe posting a sample of your code would help.

If you're trying to close a dataset with a function, it seems likely that
you've opened it with a function. Datasets are opened with the OPEN
function, and closed with the CLOSE function.

> but this does not
> help.
> Why SAS is so undocumented and sometimes _very_ stupid.

Hey, it's a machine and a piece of software - insensate and inanimate.
Words like "stupid" don't apply to such things, which don't have a brain and
are incapable of learning.


 | 
Pages: 1
Prev: Retain -- Data Structure
Next: remove last 3 characters from a string