Excel data and variables in SPSS
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.
ASKED:
Feb 1, 2012 1:30 PM GMT
UPDATED:
February 28, 2012 9:31:53 AM GMT
RELATED QUESTIONS
- Data and Variables in SPSS from Excel spreadsheet
- Transfer particular pieces of data from Excel into Word over a large number of documents
- How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?
- Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
- Matching data in Excel
- Microsoft Excel workbook sharing
- Problems oprning Excel File
- Generate binary dataset after weighing cases in SPSS
- uploading an excel spreadsheet to the as/400
- Problem with AS/400 data transfer to Excel
Answer Wiki:
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
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
15 pts.
To see other answers submitted to the Answer Wiki View Answer History.
