3 Replies Latest reply on Jun 16, 2016 4:51 AM by dtcgnet

    Exporting Data to SPSS from FileMaker

    Penny

      HI everyone

      My end users generally use SPSS to analyse our research data from FileMaker. I have been exporting to Excel and then to SPSS but was wondering if there was a simpler way to eliminate the middle step.

      Can anyone help?

      Thanks

      Penny

        • 1. Re: Exporting Data to SPSS from FileMaker
          coherentkris

          IBM SPSS can use ODBC to connect directly to an FM database.

          If that is the SPSS package your talking about.

          I'm sure that if you research IBM SPSS documentation and tech support forums you can find out how to make the product behave.

          Finding out about ODBC only took me 5 mins and i've never used the product.

          1 of 1 people found this helpful
          • 2. Re: Exporting Data to SPSS from FileMaker
            beverly

            the .sav "format" contains binary data. so no, there is no direct method to get FMP data export into SPSS. However comma-separted and tab-delimited text can also be imported into SPSS, so it's an alternative to Excel (.xlsx)

             

            Perhaps FMS can be used as an ODBC source, so that SPSS can read it directly. I have no experience with that.

            beverly

            1 of 1 people found this helpful
            • 3. Re: Exporting Data to SPSS from FileMaker
              dtcgnet

              Can you send us an example of the SPSS language you're using for defining the data? Is the data usually just a bunch of fixed length records?

               

              In my copy of SPSS, I'm most familiar with something like:

               

              Data List File = Myfile.txt Records=1

              /Var1 to Var10 1-10 Var11 11-12 Var12 to Var 20 13-21.

               

              Something like that. Is that similar to what you have?