Re: "ERROR I/O" on a large database on version 0.7.9 Win7 binary

[John Darrington]

On Sat, Jun 02, 2012 at 10:35:04AM +0000, Gong, Henry wrote:
     Hi,
     
     Thanks for looking at the files. Here is the syntax I've been using:
     
     >GET DATA
     > /TYPE=TXT
     > /FILE="C:\path\to\file\file.csv"
     > /ARRANGEMENT=DELIMITED
     > /IMPORTCASE=ALL
     > /DELIMITERS=";"
     > /VARIABLES=
     >    VAR001 F4.0
                 ^^^^  This is the problem.

You have told pspp that the variable VAR001 is decimal format of width 4.  But 
the data contains
a V so it complains.  You need to change that F4.0 to something like A8  and 
the same for all 
variables which are not numeric.
     
     
     I did a little further testing with the command line: when I try to use 
LIST I can specify, say, a thousand cases and they get output just fine. 
However, LIST for all cases results in the aforementioned error. It might be 
more accurate to say that the error is not in GET DATA; rather, the error is in 
LIST (and perhaps other functions that use the whole dataset).
     
     Here is my LIST syntax:
     >LIST
     > /CASES=FROM 1 TO 1000
     > /FORMAT=NUMBERED SINGLE.
     which works. But
     >LIST
     > .
     does not work.
     
Can you try :

SHOW N.
and
FREQUENCIES ALL /FORMAT=NOTABLE.

both of which should tell you how many cases pspp thinks the dataset has.
Do this after you've fixed the format; it's difficult to diagnose the second 
problem until the
first has been fixed.

J'


-- 
PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See http://keys.gnupg.net or any PGP keyserver for public key.

signature.asc
Description: Digital signature