When SPSS reads an excel file, can it automatically remove blanks from headers.

[Art Kendall]

I do not have access to SPSS today or I could just test this.
Does version 21 have an option to read an Excel file and collapse column Headers by removing blanks?
e.g. "Date of Birth" ==> "DateofBirth"
or
"First Name" ==> "FirstName"

[Jon K Peck]

Statistics 22 compresses blanks out automatically, but 21 replaces the name with Vnnn.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Art Kendall <[hidden email]>
To:        [hidden email],
Date:        04/05/2014 08:41 AM
Subject:        [SPSSX-L] When SPSS reads an excel file,              can it automatically remove blanks from headers.
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I do not have access to SPSS today or I could just test this.
Does version 21 have an option to read an Excel file and collapse column Headers by removing blanks?
e.g. "Date of Birth" ==> "DateofBirth"
or
"First Name" ==> "FirstName"
--
Art Kendall
Social Research Consultants

Art Kendall
Social Research Consultants

---

View this message in context: When SPSS reads an excel file, can it automatically remove blanks from headers.
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

[Jignesh Sutar]

There was a bug/inconsistency in this. IIRC, if it contained a blank then then the blank would be removed and the remainder of the string would be used as the variable name but if it contained a illegal character (for a variable name) then it would use the V# convention instead (rather than simply removing the illegal character). I remember it to be something along these line. I filled a bug report which was accepted and fixed in the latest V22 fix pack. See notes below

https://www-304.ibm.com/support/entdocview.wss?uid=swg1PM85225

Error description

• In v 21 when importing from Excel, if the variable name contains
  an illegal character like a space or a . it renames the variable
  to V18 or V23 -- the number corresponding to the position of the
  variable in the file.  In other manifestations, it simply strips
  the '.' character from the fieldname.
  

Local fix

• This issue will be addressed in a future Fix Pack. Please refer
  to the Fix Pack schedule at
  http://www-01.ibm.com/support/docview.wss?uid=swg21599157 for
  information on upcoming Fix Packs.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of SPSS Statistics wanting to read from MS Excel       *
  * (*.xlsx) files                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ILLEGAL VARIABLE NAMES FROM EXCEL ARE RENAMED                *
  * INAPPROPRIATELY                                              *
  * (E.G. 'MY VARNAME' BECOMES 'V12')                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to SPSS Statistics 21.0 Fixpack 2 (21.0.0.2)          *
  ****************************************************************
  

Problem conclusion

• This issue has been resolved for SPSS Statistics 21.0 Fixpack 2
  (21.0.0.2)

• 
  
  APAR Information
  
  
  
  
  
  
  APAR number
  PM85225
  
  
  
  
  Reported component name
  SPSS STATISTICS
  
  
  
  
  
  Reported component ID
  5725A54ST
  
  
  
  
  
  Reported release
  L00
  
  
  

On 5 April 2014 15:45, Jon K Peck <[hidden email]> wrote:

Statistics 22 compresses blanks out automatically, but 21 replaces the name with Vnnn.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Art Kendall <[hidden email]>
To:        [hidden email],
Date:        04/05/2014 08:41 AM
Subject:        [SPSSX-L] When SPSS reads an excel file,              can it automatically remove blanks from headers.
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I do not have access to SPSS today or I could just test this.
Does version 21 have an option to read an Excel file and collapse column Headers by removing blanks?
e.g. "Date of Birth" ==> "DateofBirth"
or
"First Name" ==> "FirstName"
--
Art Kendall
Social Research Consultants

Art Kendall
Social Research Consultants

---

View this message in context: When SPSS reads an excel file, can it automatically remove blanks from headers.
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

[Art Kendall]

Okay I must have been remembering the Beta of SPSS 22.
Things are still messed up with my receiving a regular SPSS22 access code
On 4/5/2014 10:51 AM, Jon K Peck [via SPSSX Discussion] wrote:

Statistics 22 compresses blanks out automatically, but 21 replaces the name with Vnnn.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Art Kendall <[hidden email]>
To:        [hidden email],
Date:        04/05/2014 08:41 AM
Subject:        [SPSSX-L] When SPSS reads an excel file,              can it automatically remove blanks from headers.
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I do not have access to SPSS today or I could just test this.
Does version 21 have an option to read an Excel file and collapse column Headers by removing blanks?
e.g. "Date of Birth" ==> "DateofBirth"
or
"First Name" ==> "FirstName"
--
Art Kendall
Social Research Consultants

Art Kendall
Social Research Consultants

---

View this message in context: When SPSS reads an excel file, can it automatically remove blanks from headers.
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/When-SPSS-reads-an-excel-file-can-it-automatically-remove-blanks-from-headers-tp5725325p5725326.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML