Date: Thu, 2 Dec 2004 16:23:41 +0300
Reply-To: Hector Maletta <hmaletta@fibertel.com.ar>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Hector Maletta <hmaletta@fibertel.com.ar>
Subject: Re: file already in use
In-Reply-To: <OFA6FE0EDB.2E4C9DB3-ONC2256F5E.003E5E54@csb.gov.lv>
Content-Type: text/plain; charset="us-ascii"
Martin,
I get that error message all the time after matching or aggregating files,
when I try to save a file under the same name of the file I started working
with. The only way around the problem (not quite around, in fact) is using a
different name for the file you are trying to save. If your files are very
large and you are short of disk space this still can be a problem, because
it requires that --at least for a while-- two versions of the file squeeze
together into the disk, which may thus get full, but I do not know of any
other solution.
By the way, disk space is saved by using the keyword /COMPRESSED at the end
of the SAVE command (not possible with AGGREGATE, sorry), but that is only
halfway through: unless you tell it so, SPSS would NOT use compressed format
for its temporary working files. I discovered it to my annoyance when
dealing with a (compressed) 3 Gb file the other day and tried to SORT CASES
first, to MATCH it, and to AGGREGATE it later: the working file ran up to 20
or 30 Gb, and I had only 14 Gb free on disk at the time!! The solution to
this specific hassle is the command SET COMPRESS ON, which can be issued at
any time. This command causes SPSS to use the compressed format for its
working files.
By the way again, in previous versions of SPSS there was a possibility of
having some routine syntax running automatically at the beginning of each
session, from a file called SPSSPROF.INI I believe. I used to put SET
COMPRESS ON in that piece of syntax, but SPSSPROF is no longer around I'm
afraid. I suspect there is now some autorun macro that could be used for the
same purpose, and dimly recall some exchange about it some time ago on this
list, but cannot quite find it now. Anybody remembers how to do it?
Hector
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]
> On Behalf Of Martins Liberts
> Sent: Thursday, December 02, 2004 2:36 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Re: file already in use
>
>
> Hi lister,
>
> Is there some new workaround for this annoying error?
>
> >Error # 62 in column 9. Text: C:\My
> Documents\Darbs\IntraStat\data_200407
> >The file is already in use.
> >This command not executed.
>
> CACHE.
> EXECUTE.
> Doesn't help this time for me. Probably I don't know where to
> put the cache commands, but I have tried several places, but
> still the error is popping up.
>
> I get the error after executing following commands:
>
> get file=!dataq+"\Edited\Updated\"+!varq+"_"+!subgrq+".sav".
> agg out=!dataq+"\Work\resp.sav"
> /break nmk
> /del=n.
>
> The problem obviously is with file "resp.sav".
>
> It is because previously I have run the command:
>
> match files
> /file=*
> /table=!dataq+"\Work\resp.sav"
> /in resp
> /table="C:\My Documents\Darbs\IntraStat\Ramis\"+!varq+"_2.sav"
> /in frame
> /by nmk
> /drop=del.
>
> I have tried to put cache after the match and before agg, but
> it doesn't helps.
>
> I know that it will be OK if I will just restart the SPSS
> program, but it is silly.
>
> Any ideas?
>
> --
> Martins Liberts
> Central Statistical Bureau of Latvia
> address: Lacplesa iela 1, Riga, LV-1301, Latvia
> phone: 371-7366877
> email: Martins.Liberts@csb.gov.lv
>
>
>
>
> Raynald Levesque <rlevesque@videotron.ca>
> Sent by: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
> 24.07.2004 14:18 Please respond to Raynald Levesque
>
>
> To: SPSSX-L@LISTSERV.UGA.EDU
> cc:
> Subject: Re: file already in use
>
>
> Hi
>
> * Insert the following commands before the save command:
> CACHE.
> EXECUTE.
>
> HTH
>
> Raynald Levesque rlevesque@videotron.ca
> Visit my SPSS site: http://pages.infinit.net/rlevesqu/
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On
> Behalf Of Jed J. Teres
> Sent: July 23, 2004 2:46 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: file already in use
>
>
> When I try to save a file, I am getting told that the file is
> already in use. What gives?
>
> ex:
>
> get file='d:\directory\file.sav'.
>
> save outfile='d:\directory\newfile.sav'.
>
> I am thus told that "newfile.sav" is already in use.
>
> Why??
>
> This communication is intended for the use of the recipient
> to which it is addressed, and may contain confidential,
> personal and or privileged information. Please contact us
> immediately if you are not the intended recipient of this
> communication, and do not copy, distribute, or take action
> relying on it. Any communication received in error, or
> subsequent reply, should be deleted or destroyed.
>
>
> This communication is intended for the use of the recipient
> to which it is addressed, and may contain confidential,
> personal and or privileged information. Please contact us
> immediately if you are not the intended recipient of this
> communication, and do not copy, distribute, or take action
> relying on it. Any communication received in error, or
> subsequent reply, should be deleted or destroyed.
>
>
> This communication is intended for the use of the recipient
> to which it is addressed, and may contain confidential,
> personal and or privileged information. Please contact us
> immediately if you are not the intended recipient of this
> communication, and do not copy, distribute, or take action
> relying on it. Any communication received in error, or
> subsequent reply, should be deleted or destroyed.
>
>
> This communication is intended for the use of the recipient
> to which it is addressed, and may contain confidential,
> personal and or privileged information. Please contact us
> immediately if you are not the intended recipient of this
> communication, and do not copy, distribute, or take action
> relying on it. Any communication received in error, or
> subsequent reply, should be deleted or destroyed.
>
>
> This communication is intended for the use of the recipient
> to which it is addressed, and may contain confidential,
> personal and or privileged information. Please contact us
> immediately if you are not the intended recipient of this
> communication, and do not copy, distribute, or take action
> relying on it. Any communication received in error, or
> subsequent reply, should be deleted or destroyed.
>
| 
