Troubleshooting
Problem
I'm trying to import an Excel worksheet into SPSS for Windows and I'm getting an error. It appears that any columns in an Excel worksheet containing blank cells or a formula giving an alphanumeric outcome can't be imported into SPSS. I get the following error: Warning. Command name: GET DATA (2101) The column contained no recognized type; defaulting to "Numeric[8,2]" * Column 2 And since the field in SPSS defaulted to numeric all alphanumeric data has been lost - shows up as sysmis. I can perform the importation cleanly using ODBC, but is there anything else I can do?
[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
55739
Was this topic helpful?
Document Information
Modified date:
16 April 2020
UID
swg21481049