Excel data and variables in SPSS

10 pts.
Tags:
Microsoft Excel
Microsoft Excel variables
I have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable - e.g. - invA, invB, invC, etc. rather than just listing the one inv. Is this correct in that the variables are listed separately for each question? I had already entered the variables and other information on the variable view page, but when I transferred the Excel file to the data page, it entered different variables. Any help with this will be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

When you read an Excel spreadsheet, you are creating a new data file, so any entries in the SPSS Data Editor are irrelevant.

If you checked the names-at-the-top choice, the text in the first row of the sheet or selected range in each column is used as the variable name for that column if it is a legal variable name in SPSS (no blanks, punctuation, etc). So perhaps there is something wrong with the column headers for reading into Statistics.

HTH

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following