Date:         Tue, 22 Aug 2006 09:28:59 -0400
Reply-To:     Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Subject:      Re: Message error
Comments: To: Yom Sas <yomsas@GMAIL.COM>

Yom

persuade the source of your syntax
>%let nbrtests = %sysfunc(attrn(%sysfunc(open(work.resum,i)),NLOBS));
to explain what to do when it doesn't work.

Or check out the on-line doc and samples for code that _will_ work.
 ..... .... it's only a short learning-curve away ....  ....

The reason we don't get that error is that we don't do it that way!


Good Luck
Peter


On Tue, 22 Aug 2006 12:27:21 +0200, yom <yomsas@GMAIL.COM> wrote:

>In fact my table is still in use because of this code :
>
>%let nbrtests = %sysfunc(attrn(%sysfunc(open(work.resum,i)),NLOBS));
>
>That is the reason why I cannot update it. Do you know which code i have
to
>add so as to liberate it.
>
>Thanks a lot !
>
>yom
>
>
>
>2006/8/22, Gwenael Besnier <gwen_1973@hotmail.com>:
>>
>> That's the point: liberate it means close it after opening!
>> Usually this error message occurs when you forget to close an opened
>> dataset, check that you close it after opening, or don't forget any quit
>> after proc dataset, etc...
>>
>> >From: yom <yomsas@gmail.com>
>> >To: "Gwenael Besnier" <gwen_1973@hotmail.com>
>> >Subject: Re: Message error
>> >Date: Tue, 22 Aug 2006 11:30:55 +0200
>> >
>> >I have only imported this table from an excel file. When I want to
update
>> >this table, I get this message. How can I do so as to liberate it ?
>> >
>> >yom
>> >
>> >
>> >2006/8/22, Gwenael Besnier <gwen_1973@hotmail.com>:
>> >>
>> >>Hi,
>> >>
>> >>maybe you have an dsid=open(work.RESULTAT) without close...
>> >>
>> >>Gwen
>> >>
>> >>
>> >> >From: yom <yomsas@GMAIL.COM>
>> >> >Reply-To: yom <yomsas@GMAIL.COM>
>> >> >To: SAS-L@LISTSERV.UGA.EDU
>> >> >Subject: Message error
>> >> >Date: Tue, 22 Aug 2006 11:08:11 +0200
>> >> >
>> >> >Dear All,
>> >> >
>> >> >Here is a message displayed in log window. However this table is not
>> >> >opened.
>> >> >Thank you very much in advance.
>> >> >
>> >> >yom
>> >> >
>> >> >
>> >> >ERROR: You cannot open WORK.RESULT.DATA for output access with
>> >>member-level
>> >> >control because
>> >> >WORK.RESULT.DATA is in use by you in resource environment DATASTEP.
>> >>
>> >>_________________________________________________________________
>> >>Sie suchen E-Mails, Dokumente oder Fotos? Die neue MSN Suche Toolbar
mit
>> >>Windows-Desktopsuche liefert in sekundenschnelle Ergebnisse. Jetzt
neu!
>> >>http://desktop.msn.de/ Jetzt gratis downloaden!
>> >>
>> >>
>>
>> _________________________________________________________________
>> Sie suchen E-Mails, Dokumente oder Fotos? Die neue MSN Suche Toolbar mit
>> Windows-Desktopsuche liefert in sekundenschnelle Ergebnisse. Jetzt neu!
>> http://desktop.msn.de/ Jetzt gratis downloaden!
>>
>>