Problem Note 60059: SAS® numeric variables are incorrectly stored as character variables when exported to SPSS using SAS/ACCESS® Interface to PC Files
 |  |  |  |  |
When you create an SPSS (.sav) file using the EXPORT procedure, numeric columns are incorrectly stored as character data types in the output file.
This problem occurs when the SAS data set contains mixed numeric and character columns, and one or more character columns is longer than 255 bytes in width.
To work around the problem, ensure that character columns are less than 255 bytes wide before exporting the data to SPSS.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for x64 | 9.4 TS1M4 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M4 | 9.4 TS1M4 | ||
A fix for this issue for SAS/ACCESS Interface to PC Files 9.4_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A7I.html#60059
Columns with numeric data type are incorrectly stored as character data types when exported to SPSS. This problem occurs when the SAS source data contains character columns longer than 255 bytes in width.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-03-27 14:38:40 |
| Date Created: | 2017-03-01 08:53:20 |