Hi Jake,
I had and still have got the same problem. There were two columns in the
data frame which contain just missing values. When I deleted those the
impord seemed to work, but there is still a warning message.
Warning message:
C:\test.sav: Unrecognized record type 7, subtype 13 encountered in
system file.
>
Jake Wegelin wrote:
> Is there any documentation on what kind of SPSS file can and cannot be
> read by read.spss? Alternatively, how can one modify or "clean"
an SPSS
> file to make it readable by read.spss? What properties must a *.sav file
> before read.spss can read it?
> The file in this example is 270KB, with 5 rows and 173 columns. I
have no
> trouble reading larger files with read.spss, so it's not merely a size
> problem. I have no difficulty opening the file in SPSS. I also have no
> trouble getting read.spss to read a dummy SPSS file with 5 rows and 173
> columns, where each entry was randomly sampled from c(letters, LETTERS).
> /> library("foreign") /
> /> junk<-read.spss("indata/z2EXvideo.sav") /
> Error in read.spss("indata/z2EXvideo.sav") :
> Error reading system-file header.
> In addition: Warning message:
> indata/z2EXvideo.sav: File layout code has unexpected value 50331648.
Value should be 2, in
> big-endian or little-endian format.
> Thanks for any information
> Jake Wegelin
/> version /
Bj?rn Stollenwerk <b.stollenwerk at gmx.de> wrote:> I had and still have got the same problem. There were two columns in the > data frame which contain just missing values. When I deleted those the > impord seemed to work, but there is still a warning message.> Warning message: > C:\test.sav: Unrecognized record type 7, subtype 13 encountered in > system file. >This warning message has been discussed a few times. It occurs when read.spss reads a file from SPSS 12.0 or higher. Beginning with SPSS 12 the file format was changed to accommodate long variable names. It seems logical that SPSS added a record to their file format to hold the long variable names, while keeping the short (eight character) variable names to be compatible with older versions. The read.spss function has not been updated. It reads the short names, ignores the long names, and produces the warning you cite. There does not seem to be any error in reading the data, other than the warning and continued use of short variable names. I brought this up more than a year ago, just after SPSS 12 was released. I e-mailed the author (Saikat DebRoy) of the read.spss function, but did not get a response, I don't know if he got the message. It would be nice to update the function to read the longer variable names and be rid of the warning. Harold