LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 1998)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 28 Aug 1998 12:20:36 -0500
Reply-To:     "Nichols, David" <nichols@SPSS.COM>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From:         "Nichols, David" <nichols@SPSS.COM>
Subject:      Re: Crosstabs / V8.0 / SNAFU

It appears you've hit a known bug affecting Releases 8.0 and 8.0.1. If you run CROSSTABS with multiple tables in one run (i.e., you have two or more row or column variables in the dialog) and you have a long string variable, you get wrong counts. This should be fixed in 8.0.2. Workarounds include running one table at a time and changing the long string to a shorter one or numeric. Apologies for the inconvenience.

David Nichols Principal Support Statistician and Manager of Statistical Support SPSS Inc.

-----Original Message----- From: R. Allan Reese [SMTP:R.A.Reese@GRI.HULL.AC.UK] Sent: Friday, August 28, 1998 9:18 AM To: SPSSX-L@UGA.CC.UGA.EDU Subject: Crosstabs / V8.0 / SNAFU

Contrary to previous broadcast, I found I did have a journal and could reproduce the error on a much reduced datafile. In case it is relevant, the data were input to Excel 5, saved as Excel 4, imported, saved as .SAV . However, the .SAV file was then cut down and saved as SPSS portable, but still shows the same error.

It appears that if I ask for a single Xtabs table, I get a sensible result (though I haven't independently checked it is "correct"), but when I ask for two tables in one command I get total rubbish. Perhaps SPSS now needs a pop-up box saying, "I accept now that the answers I gave when you last issued this command were not entirely appropriate."

Who would like the .POR file sending?

--- text version of output.

IMPORT FILE='G:\PHD\xtabbug.por'. EXECUTE . CROSSTABS /TABLES=software BY olspell /FORMAT= AVALUE TABLES /CELLS= COUNT .

Crosstabs

Case Processing Summary

Cases

Valid Missing Total Percen Percen Percen N t N t N t SOFTWARE * 98 100.0% 0 .0% 98 100.0% OLSPELL

SOFTWARE * OLSPELL Crosstabulation

Count

OLSPELL a b c d Total SOFTWARE !edit 1 1 Q&A 1 1 a 5 8 12 26 51 a+b 3 1 4 a+vi 1 1 ami 1 1 b 1 3 4 8 b,vis page 1 4 5

c 1 1 clarisw 2 2 orks emacs 1 2 2 1 6 jed 1 1 lhe? 1 1

mmail 1 1 nisus 1 2 3 pff 1 1 tex 1 2 2 1 6 ventura 1 1

vi 1 1 2 works 1 1 Total 10 20 19 49 98

CROSSTABS /TABLES=software BY olthes /FORMAT= AVALUE TABLES /CELLS= COUNT .

Page 1

Case Processing Summary

Cases

Valid Missing Percen Total Percen Percen N t N t N t SOFTWARE * 98 100.0% 0 .0% 98 100.0% OLTHES

SOFTWARE * OLTHES Crosstabulation

Count

OLTHES a c d Total 1 b SOFTWARE !edit 1 Q&A 1 1 a 18 27 3 3 51 a+b 1 2 1 4 a+vi 1 1 ami 1 1 b 4 2 2 8 b,vis page 4 1 5

c 1 1 clarisw 2 2 orks emacs 5 1 6 jed 1 1 lhe? 1 1

mmail 1 1 nisus 1 1 1 3 pff 1 1 tex 6 6 ventura 1 1

vi 2 2 works 1 1 Total 52 33 10 3 98

CROSSTABS /TABLES=software BY olspell olthes /FORMAT= AVALUE TABLES /CELLS= COUNT .

Crosstabs

Page 2

Case Processing Summary

Cases

Valid Missing Percen Percen Total Percen N t N t N t SOFTWARE * 98 100.0% 0 .0% 98 100.0% OLSPELL SOFTWARE * OLTHES 98 100.0% 0 .0% 98 100.0%

SOFTWARE * OLSPELL Crosstabulation

Count

OLSPELL a b c d Total SOFTWARE !edit 1 1 1 Q&A 1 1 a 5 8 12 26 51 a+b 3 1 4 a+vi 1 1 ami 1 1 b 1 3 4 8 b,vis page 1 4 5

c 1 1 clarisw 2 2 orks emacs 1 2 2 1 6 jed 1 1 lhe? 1 1

mmail 1 1 nisus 1 2 3 pff 1 1 tex 1 2 2 1 6 ventura 1 1

vi 1 1 works 1 1 Total 10 20 19 49 98

SOFTWARE * OLTHES Crosstabulation

Count

OLTHES c d Total !edit 1 1 1 3 3 SOFTWARE a 51 a+b 1 3 b 2 4 8 b,vis 1 4 5 page clarisw 2 2 orks emacs 1 5 6 nisus 1 1

tex 6 6 vi 2 2 Total 10 3 98

DISPLAY DICTIONARY.

File Information

List of variables on the working file

Name Position

OLSPELL 1 Measurement Level: Nominal Column Width: Unknown Alignment: Left Print Format: A9 Write Format: A9

OLTHES 3 Measurement Level: Nominal Column Width: Unknown Alignment: Left Print Format: A9 Write Format: A9

SOFTWARE 5 Measurement Level: Nominal Column Width: Unknown Alignment: Left Print Format: A11 Write Format: A11 --------------------------------

R. Allan Reese Email: r.a.reese@gri.hull.ac.uk Associate Manager Direct voice: +44 1482 466845 Graduate Research Institute Voice messages: +44 1482 466844 Hull University, Hull HU6 7RX, UK. Fax: +44 1482 466846 ==================================================================== Hull: a 1st Division University (Daily Telegraph, London 20/8/97)


Back to: Top of message | Previous page | Main SPSSX-L page