[R] spss-data import

Peter Malewski p.malewski at tu-bs.de
Sat Jun 9 18:31:17 CEST 2001


On Sat, Jun 09, 2001 at 03:57:29PM +0200, Bernd Weiss wrote:
> Error in read.table("d:/fixed.dat", header = T) : 
>         all rows must have the same length.

Look at your exported data-file an you'll see how you have to read
it. My standard way to read excel csv files is:

Akten1998.1 <- read.csv("File.csv",sep=";",as.is=T,dec=",")

But this depends on several cirumstances. E.g. on some windows
platforms the "dec" is set to "." (I think you can set this with spss). 

Spss often uses tabs as seperators (depends how you export your file 
in spss) so 

sep="\t"

should work.

My experience with read.spss:

1. Works often with spss version 6-9...
2. ...mut sometimes crash with these files (I have at least one file
that is not readable).
3. Don't work with spss version 10 files. Even spss 6 cannot read
them. 

So: 
while (!success)
	exoport from spss with other options
	look at the file
	specify read.xxx parameter

Peter


-- 
P.Malewski, Limmerstr.47, 30451 Hannover, 0511-2135008
At work: http://www.MH-Hannover.de 0511 532 3194 / Fax: 0511 532 3190, 
P.Malewski at tu-bs.de, peter.malewski at gmx.de, malewski.peter at mh-hannover.de.
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list