I use the spanish version of spss v15.0.1 with the hotfix for vista, and
when i run the following sintax in a large database:
CROSSTABS
/TABLES=Dur BY ID
/FORMAT= AVALUE TABLES
/CELLS= COUNT
/COUNT ROUND CELL .
I have this result:
Recuento
ID Total
0 1 4 5 6 0
---------------------------------------------------------------
Dur -7 0 0 0 1 0 1
-6 0 0 1 1 0 2
-3 0 0 0 1 0 1
-1 0 1 0 1 0 2
0 214 842636 210488 0 0 1151012
1 20 29072 7899 0 0 41290
2 23 30661 7630 0 0 42603
3 10 31295 7160 0 0 85927
4 4 31113 6094 0 0 40769
5 32 31229 8467 0 0 43348
6 6 31202 113124 0 0 179317
7 2 28802 6261 0 0 38122
8 1 27557 5871 0 0 36445
9 7 24971 5403 0 0 53533
10 0 18210 4171 0 0 24761
11 49 121920 26594 0 0 163810
Total 368 1248669 409163 241893 850 1900943
The values of Total row are ok, but the columns ID=5 and 6 are 0!
Now if I filter by ID=5, just to check what happends.
USE ALL.
COMPUTE FILTER=(ID=5).
FILTER BY FILTER.
EXECUTE .
CROSSTABS
/TABLES=Dur BY ID
/FORMAT= AVALUE TABLES
/CELLS= COUNT
/COUNT ROUND CELL .
USE ALL.
Recuento
ID Total
5 5
---------------------------------
Dur -7 1 1
-6 1 1
-3 1 1
-1 1 1
0 1 97181
1 0 4173
2 0 4238
3 0 47446
4 0 3550
5 0 3583
6 0 34972
7 0 3056
8 0 3011
9 0 23150
10 0 2377
11 0 15152
Total 241893 241893
(?)!!!!!
I think the problem is with the size of the database, because i try with
smaller examples and the crosstabs works ok.
I try with diferents variables with %col and %row, and the problmen is
always the same, in some point, the crosstabs cells show always 0, but the
totals values are ok.
This patch of spss support don't mention to solve this problem.(and is
only for english versions)
http://support.spss.com/Student/Patches/SPSS/Windows/15.0.1.1/15.0.1.1_Readme.html
It happens only in vista hotfix?, any idea?
Any new pacht coming?
Thanks a lot
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
