Date: Fri, 28 Jun 2002 21:49:37 -0400
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Arthur J. Kendall" <Arthur.Kendall@VERIZON.NET>
Subject: Re: URGENT - I need understanding/help Friday 28th, if possible
Content-Type: text/plain; charset=us-ascii
I believe that there is an Excel limitation of 16000 cases.
Are most of your variables single digit? Like scale items?
You should be able to open the tab delimited file in wordPerfect
set your page size to ledger, landscape, a small font say , set margins to min, set
tabs to every.2 in except the id.
What does your C++ program do? Maybe you can run the same thing in SPSS to compare
Can your C++ program be changed to read comma separated or fixed format?
Are most of your variables single digit?
Leslie Henrickson wrote:
> Hi, ListServe Members,
> I am mystified by something that is causing me problems.
> I have an SPSS datafile that I have recoded all variables to have no blanks
> or missing values, e.g. all missing are recoded to 0. There are 68
> variables and 40,080 cases. I save this file as both a tab delimited file
> and a xls file, both are supposed to be the same in content but I'm trying
> two ways of working with the data.
> I save it in these formats because I've written a C++ program that reads
> this in as input file and it can't tolerate blank fields. But my C++ code
> output is wrong and I'm troubleshooting.
> When I open up the xls file there are only 16,000 cases saved. I have
> repeated the save process and can't seem to save more than this number of
> cases in Excel file. BUT, all the variables are filled in and there are no
> I don't know how to open the .dat file to inspect it (the dialog box says
> that the file is used by the operating system and opening and/or editing
> could damage system). I try two ways to open it. One, I open it anyway
> with Textpad editor. In this mode all the 41K cases come through BUT there
> are blank fields. Two, I change the extension from dat to xls and open
> this in Excel. In this mode all the 41K cases come through BUT there are
> blank fields.
> I'm mystifed on how to get the output file that I want. I need all 41,080
> cases and no blank fields. Initially saving as Excel file shows that my
> recodes seemed to work, as no blanks showed up, but not all cases came through.
> Do you have any insight and can you help me today, Friday June 28th?
> Leslie Henrickson