APAR status
Closed as program error.
Error description
You are reading your numeric and string data from Excel (*.xlsx) into Statistics 20. Columns which should have decimal portions are appearing in Statistics 20 with the integer portion only.
Local fix
Check the format of your numeric field. Numeric fields formatted as "General" appear to be coming in this way. change the format to "Number", and the values come in correctly.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users importing decimal values from Excel (*.xlsx) where the * * data fields are numeric thought formatted in Excel as * * "General" * **************************************************************** * PROBLEM DESCRIPTION: * * You are reading your numeric and string data from Excel * * (*.xlsx) * * into Statistics 20. Columns which should have decimal * * portions * * are appearing in Statistics 20 with the integer portion * * only. * **************************************************************** * RECOMMENDATION: * * Update to Statsitics 20 Fixpack 1 * ****************************************************************
Problem conclusion
Update to Statsitics 20 Fixpack 1
Temporary fix
Comments
APAR Information
APAR number
PM49520
Reported component name
SPSS STATISTICS
Reported component ID
5725A54ST
Reported release
K00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-10-06
Closed date
2012-02-16
Last modified date
2012-02-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
SPSS STATISTICS
Fixed component ID
5725A54ST
Applicable component levels
RK00 PSN
UP
RK00 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQ88K","label":"Statistics Desktop"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
16 February 2012