|Date: ||Sat, 27 Dec 2003 11:32:06 +1100|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||Simon Freidin <email@example.com>|
|Subject: ||Re: Problems saving data to excel with labels|
I'd suspect insufficient memory is the cause.
Can they test whether they still have these problems if they use a workstation with 512K RAM?
Alternatively, do they still have these problems with a smaller dataset ie 25000 or 50000 cases?
Can they free up as much memory as possible, ie shut down all other applications, disable non-critical background processes.
Filters/temporary are processed significantly more slowly than permanent select if.
In message <AOEGICAIDINDKMJMFMFECEDCCBAA.firstname.lastname@example.org> Vito Palligas <support2@SPSS.CL>
> Hello all,
> We have a client that has the following problems using SPSS 22.214.171.124 who
> works with PC's that use 256 RAM and a Pentium IV processor and administer
> the licenses using SPSSlm on their LAN:
> 1. Data files aren't being saved properly from SPSS to Excel using the 'Save
> value labels where defined instead of data values' option. Before when they
> were using SPSS 11.5.1 and they contacted us about this, we suggested that
> they install the patch to update the version to 126.96.36.199. They did so, but
> this didn't solve the problem. Whenever they attempt to save as an xls file
> sometimes when they open the file only Excel opens without an active work
> sheet. Other times Excel opens a work sheet with the variables saved from
> SPSS, but there is loss of data with many cells that should have valid
> values which appear as null with the typical text #Null! that appears for
> missing numeric values saved from SPSS to Excel.
> 2. SPSS hangs realizing simple operations. Whenever they apply functions
> such as filters it takes SPSS a long time to process the data. They don't
> have that many cases in the data files. The average size of a data set is
> about 100,000 cases. Before, they had the license administration configured
> in such a way that the clients had thin installations of SPSS. When they
> told us about this, we suggested that instead of using thin clients they use
> a full installation of the software. This didn't solve the problem, and SPSS
> hangs as before.
> Does someone have any suggestions on how to solve these problems?
> Thanks in advance,
> Vito Palligas
> SPSS Chile