survey moneky and spss

[bruce phillips-2]

I did a web survey of the parents in my kid's high school (accreditation visit).  I forget exactly what worked how, but I do remember  SM would spread out answers over multiple columns for alpha choices. For example, the single answer ethnicity answers were given in columns so that "African american appeared in the Afrian Ameican column.  I changed the labels to unbers in excell and then wrote new code in spss to make a single variable along the lines of "IF (AA=1) ETHNIC=1.
It took a lot of labor butyou can see what is going on if you know your quesitonnaire.

Bruce Phillips
USC



Does anyone have experience with exporting Survey Monkey data into Excel and then SPSS? There are some weird things happening and I don't know if it is a matter of setting different options in Survey Monkey, or whether SM just won't do what I want it to..in particular, I am trying to export questions with Likert type answer categories and it keeps creating a variable for each category, rather than a single variable with multiple categories.Another option is to recode the variables into a single one in SPSS, which I also do not know how to do..



Thanks



Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Feinstein, Zachary]

I worked with someone within the past year who was able to automatically
do it.  They had no programming experience whatsoever either.

Zachary

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
bruce phillips
Sent: Monday, February 04, 2008 11:40 PM
To: [hidden email]
Subject: survey moneky and spss

I did a web survey of the parents in my kid's high school (accreditation
visit).  I forget exactly what worked how, but I do remember  SM would
spread out answers over multiple columns for alpha choices. For example,
the single answer ethnicity answers were given in columns so that
"African american appeared in the Afrian Ameican column.  I changed the
labels to unbers in excell and then wrote new code in spss to make a
single variable along the lines of "IF (AA=1) ETHNIC=1.
It took a lot of labor butyou can see what is going on if you know your
quesitonnaire.

Bruce Phillips
USC



Does anyone have experience with exporting Survey Monkey data into Excel
and then SPSS? There are some weird things happening and I don't know if
it is a matter of setting different options in Survey Monkey, or whether
SM just won't do what I want it to..in particular, I am trying to export
questions with Likert type answer categories and it keeps creating a
variable for each category, rather than a single variable with multiple
categories.Another option is to recode the variables into a single one
in SPSS, which I also do not know how to do..



Thanks



Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list
of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Leah Quinlivan]

On the survey monkey web site http://www.surveymonkey.com/,  there is
instructions as follows:

   How can I export into SPSS?

While we do not currently do a direct export into SPSS, a number of
customers have been able to successfully transfer our export format into
SPSS.

*Please note:* You will need to export the data into Excel and then modify
the spreadsheet to take into SPSS.

Make sure to request the All Responses
Collected<http://www.surveymonkey.com/HelpCenter/Answer.aspx?HelpID=54>format
in the numerical text values.


Additional Information:

Here are some step-by-step instructions submitted to us by one of our
customers.

   1. In the analyze screen, click Download Responses.
   2. Choose the condensed version.
   3. Send to e-mail.
   4. Open e-mail attachment that you will receive and unzip it (you'll
   need to have Win-zip which is free for a trial period that seems to go
   forever from winzip.com).  Just go through the Win-zip "nexts".
   5. This puts it in an Excel file. I'd rename it to something you
   recognize and double click on it.  One "quirk" -- I couldn't seem to open it
   from Excel itself, even when saved.
   6. Edit the Excel file, you'll probably have to do the following,
   though I don't know for sure what your data looks like:
      - Delete row 1
      - Rename columns. These may be kind of funky.
      - I deleted the open-ended column variables.  They take up a lot
      of space and don't export well to SPSS.  You can get the open-ended
      responses nicely in survey-monkey itself.  They are not then "tied to the
      other variables, but you can probably find a work-around that
will work for
      you.
      - In some variables, you may notice that the SurveyMonkey format
      puts what you thought was one variable with several choices
(1,2,3,4) into 4
      variable, each with either blank or the number of the response
(1,2,3,4) in
      it.  I made these 4 separate variables, changed the 1,2,3,4's to 1's and
      defined the 1 (later) as a "yes."  You may not have this
problem, depending
      on the type of variables you have in SurveyMonkey.
   7. Another "quirk" -- it appeared to me that the respondents came into
   Excel in reverse order from the order in SurveyMonkey.  Double check this if
   you start to try and do some editing and it looks weird.
   8. Save this file as an Excel file.  Again, I'm not sure you can
   actually open it in Excel?
   9. Go to SPSS.
   10. Go to "open data" and select the Excel file you just worked on
   (you will then be faced with a number of selections)
      - Pre-determined format (No)
      - Delimited
      - Names (Yes)
      - 1st case is in line 2
      - Each line represents a case
      - All the cases
      - Comma delimited only
      - invalid names changed (OK)
      - Save format? Up to you. I generally don't.
      - Paste syntax? Up to you. I generally don't.
      - Finish
      - Save as an SPSS data file (.sav, I think)

This should give you a pretty clean SPSS file.  You will have to do some
variable renaming, I'm sure.  If you have more than one survey and you go to
merge them, watch the specifications on each (e.g., width etc.) because it
will not merge them unless these are exactly the same.



On 05/02/2008, Feinstein, Zachary <[hidden email]> wrote:

>
> I worked with someone within the past year who was able to automatically
> do it.  They had no programming experience whatsoever either.
>
> Zachary
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> bruce phillips
> Sent: Monday, February 04, 2008 11:40 PM
> To: [hidden email]
> Subject: survey moneky and spss
>
> I did a web survey of the parents in my kid's high school (accreditation
> visit).  I forget exactly what worked how, but I do remember  SM would
> spread out answers over multiple columns for alpha choices. For example,
> the single answer ethnicity answers were given in columns so that
> "African american appeared in the Afrian Ameican column.  I changed the
> labels to unbers in excell and then wrote new code in spss to make a
> single variable along the lines of "IF (AA=1) ETHNIC=1.
> It took a lot of labor butyou can see what is going on if you know your
> quesitonnaire.
>
> Bruce Phillips
> USC
>
>
>
> Does anyone have experience with exporting Survey Monkey data into Excel
> and then SPSS? There are some weird things happening and I don't know if
> it is a matter of setting different options in Survey Monkey, or whether
> SM just won't do what I want it to..in particular, I am trying to export
> questions with Likert type answer categories and it keeps creating a
> variable for each category, rather than a single variable with multiple
> categories.Another option is to recode the variables into a single one
> in SPSS, which I also do not know how to do..
>
>
>
> Thanks
>
>
>
> Lynn
>
>
>
> Lynn D. Disney, Ph.D., J.D., M.P.H.
>
> Data Specialist
>
> Reading First-Ohio Center
>
> John Carroll University
>
> 20700 North Park Boulevard
>
> University Heights, Ohio 44118
>
> Telephone: [phone]
>
> Email:  <mailto:[hidden email]> [hidden email]
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command SIGNOFF SPSSX-L For a list
> of commands to manage subscriptions, send the command INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>

--
Leah Quinlivan

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD