[R] how to read .sps (SPSS file extension)?

Wed Nov 26 13:05:21 CET 2008

sorry for the typo,

help(importer, package="memisc")

will do the trick.

Eik Vettorazzi schrieb:
> maybe the importers of the memisc-package will help you, but I never 
> tried them, see
>
>  help(importers,package="memisc")
>
> At a first glance it seems, that you have to split your file manually, 
> but maybe there is another way.
> hth.
>
> livio finos schrieb:
>> sorry, you are completely right!
>> sps is not the extension for portable file! sorry for the time I make 
>> you spend.
>> I try to make my problem more clear.
>> I exporting a dataset from limesurvey (a free software for internet 
>> survey). It works very fine and it allow to export in different 
>> format such as csv and excel. this fine, but what I like from spss 
>> formats is the variables labels.
>> limesurvey declares to export in spss, but it export in sps format 
>> which is not a format but a code actually. I realize it just now, 
>> sorry. I attach an extract of the code here below.
>> do you have any suggestion on how to manage that? I think it will be 
>> great if we can improve the interconnettivity among free software.
>> thanks again..
>>   livio
>>
>> NEW FILE.
>> FILE TYPE NESTED RECORD=1(A).
>> - RECORD TYPE 'A'.
>> - DATA LIST LIST / i0(A1) d1(N3) d2(DATETIME20.0) d3(A15) d4(N2) 
>> d5(N1) d6(N1) d7(N1) d8(N1) d9(N1) d10(N1) d11(N1) d12(N1) d13(N1) 
>> d14(N1) d15(N1) d16(N1) d17(N2) d18(N1) d19(N1) d20(N1) .
>>
>> - RECORD TYPE 'B'.
>> - DATA LIST LIST / i1(A1) d21(N1) d22(N1) d23(N1) d24(N1) d25(N1) 
>> d26(N1) d27(N1) d28(N1) d29(N1) d30(N1) d31(N1) d32(N1) d33(N1) 
>> d34(N1) d35(N1) d36(N1) d37(N1) d38(A37) d39(N1) d40(N1) .
>>
>> - RECORD TYPE 'C'.
>> - DATA LIST LIST / i2(A1) d41(N1) d42(N1) d43(N1) d44(N1) d45(N1) 
>> d46(N1) d47(N1) d48(N1) d49(N1) d50(N1) d51(N1) d52(N1) d53(N1) 
>> d54(N1) d55(N1) d56(N1) d57(N1) d58(N1) d59(N1) d60(N1) .
>>
>> - RECORD TYPE 'D'.
>> - DATA LIST LIST / i3(A1) d61(N1) d62(N1) d63(N1) d64(N1) d65(N1) 
>> d66(N1) d67(N1) d68(N1) d69(N1) d70(N1) d71(N1) d72(N1) d73(N1) 
>> d74(N1) d75(N1) d76(N1) d77(N1) d78(N1) d79(N1) d80(N1) .
>>
>> - RECORD TYPE 'E'.
>> - DATA LIST LIST / i4(A1) d81(N1) d82(N1) d83(N1) d84(N1) d85(N1) 
>> d86(N1) d87(N1) d88(N1) d89(N1) d90(N1) d91(N1) d92(N1) d93(N1) 
>> d94(N1) d95(N1) d96(N1) d97(N1) d98(N1) d99(N1) d100(N1) .
>>
>> - RECORD TYPE 'F'.
>> - DATA LIST LIST / i5(A1) d101(N1) d102(N1) d103(N1) d104(N1) 
>> d105(N1) d106(N1) d107(N1) d108(N1) d109(N1) .
>> END FILE TYPE.
>>
>> BEGIN DATA
>> A '8' '01-01-1980 00:00:00' 'it' '13' '1' '1' '' '1' '' '1' '1' '1' 
>> '1' '1' '4' '0' '' '1' '' '1'
>> B '' '1' '1' '1' '1' '0' '' '0' '' '2' '2' '1' '4' '2' '7' '3' '2' 
>> '0''2' '3'
>> C '3' '4' '4' '2' '2' '1' '4' '4' '2' '3' '1' '4' '1' '4' '1' '1' '4' 
>> '3' '4' '3'
>> D '1' '3' '1' '1' '1' '1' '1' '1' '1' '1' '1' '1' '2' '2' '2' '2' '3' 
>> '3' '3' '2'
>> E '2' '3' '2' '2' '0''0''0''0''0''0''0''3' '4' '4' '2' '1' '5' '2' 
>> '5' '4'
>> F '1' '2' '2' '2' '2' '1' '2' '2' '5'
>> A '9' '01-01-1980 00:00:00' 'it' '13' '2' '1' '' '1' '' '0' '' '1' 
>> '1' '1' '3' '0' '' '1' '' '1'
>> B '' '0' '' '1' '1' '0' '' '0' '' '2' '2' '1' '4' '3' '7' '3' '2' 
>> '0''2' '4'
>> C '3' '4' '4' '3' '3' '3' '4' '3' '2' '2' '1' '3' '1' '4' '1' '4' '4' 
>> '4' '4' '3'
>> D '1' '2' '1' '1' '1' '1' '1' '1' '1' '1' '1' '1' '3' '1' '3' '3' '3' 
>> '3' '3' '3'
>> E '3' '3' '3' '2' '0''0''0''0''0''0''0''3' '4' '2' '2' '5' '3' '5' 
>> '2' '5'
>> F '1' '5' '5' '5' '5' '5' '5' '2' '5'
>> A '10' '01-01-1980 00:00:00' 'it' '13' '1' '1' '' '1' '' '1' '2' '0' 
>> '' '0' '' '0' '' '1' '' '1'
>> B '' '1' '2' '0' '' '0' '' '0' '' '1' '2' '1' '4' '6' '7' '3' '2' 
>> '0''3' '3'
>> C '4' '4' '4' '4' '3' '4' '4' '3' '2' '2' '1' '4' '1' '4' '1' '3' '4' 
>> '4' '4' '1'
>> D '1' '1' '1' '1' '1' '1' '1' '1' '1' '1' '1' '3' '3' '3' '3' '3' '3' 
>> '3' '3' '3'
>> E '3' '3' '3' '2' '0''0''0''0''0''0''0''5' '4' '5' '2' '5' '5' '5' 
>> '5' '5'
>> F '1' '5' '5' '5' '5' '5' '5' '1' '5'
>> END DATA.
>> EXECUTE.
>>
>> *Define Variable Properties.
>> VARIABLE LABELS d1 'Record ID'.
>> VARIABLE LABELS d2 'Data di completamento'.
>> VARIABLE LABELS d3 'Lingua di partenza'.
>> VARIABLE LABELS d4 'EtÃ :'.
>> VARIABLE LABELS d5 'Sesso:'.
>> VARIABLE LABELS d6 '3 - PapÃ '.
>> VARIABLE LABELS d7 'Com&apos;Ã¨ composta la tua famiglia? - COMMENT'.
>> VARIABLE LABELS d8 '3 - Mamma'.
>> VARIABLE LABELS d9 'Com&apos;Ã¨ composta la tua famiglia? - COMMENT'.
>> VARIABLE LABELS d10 '3 - Fratelli nÂ°'.
>> VARIABLE LABELS d11 'Com&apos;Ã¨ composta la tua famiglia? - COMMENT'.
>> VARIABLE LABELS d12 '3 - Sorelle nÂ°'.
>> VARIABLE LABELS d13 'Com&apos;Ã¨ composta la tua famiglia? - COMMENT'.
>> VARIABLE LABELS d14 '3 - Nonni nÂ°'.
>> VARIABLE LABELS d15 'Com&apos;Ã¨ composta la tua famiglia? - COMMENT'.
>> VARIABLE LABELS d16 '3 - Altre figure parentali (zii, cugini, ecc.) 
>> nÂ°'.
>> VARIABLE LABELS d17 'Com&apos;Ã¨ composta la tua famiglia? - COMMENT'.
>> VARIABLE LABELS d18 '4 - PapÃ '.
>> VARIABLE LABELS d19 'QualiÂ di queste personeÂ vivono in casa con te? 
>> - COMMENT'.
>> VARIABLE LABELS d20 '4 - Mamma'.
>> VARIABLE LABELS d21 'QualiÂ di queste personeÂ vivono in casa con te? 
>> - COMMENT'.
>> VARIABLE LABELS d22 '4 - Fratelli nÂ°'.
>> VARIABLE LABELS d23 'QualiÂ di queste personeÂ vivono in casa con te? 
>> - COMMENT'.
>> VARIABLE LABELS d24 '4 - Sorelle nÂ°'.
>> VARIABLE LABELS d25 'QualiÂ di queste personeÂ vivono in casa con te? 
>> - COMMENT'.
>> VARIABLE LABELS d26 '4 - Nonni nÂ°'.
>> VARIABLE LABELS d27 'QualiÂ di queste personeÂ vivono in casa con te? 
>> - COMMENT'.
>> VARIABLE LABELS d28 '4 - Altre figure parentali (zii, cugini, ecc.) 
>> nÂ°'.
>> VARIABLE LABELS d29 'QualiÂ di queste personeÂ vivono in casa con te? 
>> - COMMENT'.
>>
>>
>> *Define Value labels.
>> VALUE LABELS d5
>> 1 "Maschio"
>> 2 "Femmina".
>> VALUE LABELS d6
>> 1 "SÃ¬"
>> 0 "Non selezionato".
>> VALUE LABELS d8
>> 1 "SÃ¬"
>> 0 "Non selezionato".
>>
>>
>>
>>
>> On Tue, Nov 25, 2008 at 10:27 AM, Eik Vettorazzi 
>> <E.Vettorazzi at uke.uni-hamburg.de 
>> <mailto:E.Vettorazzi at uke.uni-hamburg.de>> wrote:
>>
>>     Hi Livio,
>>     I think you mixed something up. The .sps - files are the syntax
>>     files of SPSS, and I think there is no automated way (but I would
>>     like to be corrected there) of converting SPSS syntax to R-code.
>>     The usual data files of spss  have the extension .sav. Such files
>>     can easily read by read.spss (package foreign) or spss.get
>>     (package Hmisc), if you think the variable labels of SPSS are
>>     fancy the latter approach is possibly more appropriate, because it
>>     adds an attribute with this label to each row.
>>     hth.
>>
>>
>>
>>     livio finos schrieb:
>>
>>         Hi everyone,
>>         I'm trying to import .sps (SPSS portable file) file.
>>         the read.spss function (library foreign) doesn't allow to
>>         import such files.
>>         should I import in spss and then save as sav file? there is
>>         not other
>>         solutions available?
>>         what I mostly like from spss file is that they have variable
>>         labels.
>>         want is really wish to keep are the variable.labels from the
>>         spss file; so,
>>         if there is a different way to bring them from the sps file
>>         will be also ok
>>         (I also have a csv copy but without the variable.labels
>>         obviously).
>>         thanks for any answer..
>>          livio
>>
>>                [[alternative HTML version deleted]]
>>
>>         ______________________________________________
>>         R-help at r-project.org <mailto:R-help at r-project.org> mailing list
>>         https://stat.ethz.ch/mailman/listinfo/r-help
>>         PLEASE do read the posting guide
>>         http://www.R-project.org/posting-guide.html
>>         and provide commented, minimal, self-contained, reproducible 
>> code.
>>         
>>
>>     --     Eik Vettorazzi
>>     Institut für Medizinische Biometrie und Epidemiologie
>>     Universitätsklinikum Hamburg-Eppendorf
>>
>>     Martinistr. 52
>>     20246 Hamburg
>>
>>     T ++49/40/42803-8243
>>     F ++49/40/42803-7790
>>
>>
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.