Problem Note 20851: SASĀ® Marketing Automation returns "Error: variable has been defined as both character and numeric"
SAS Marketing Automation provides the ability to add a list of seeds to
communication exports. Each list can include a number of both numeric
and alphanumeric fields to match the fields being exported along with
"seed" data to populate those fields.
If, however, you have a character field that contains only numeric
values defined in the seed list, you might see this error when the
communication being executed exports its target audience:
ERROR: variable [VARIABLE NAME] has been defined as both character and
numeric.
There are two simple workarounds for this error:
1. Ensure that the seeds list field has one or more rows containing
character information.
2. Do not give the field a format in the export definition. Usually it
defaults to $x. Change this to blank.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Marketing Automation-Server | Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows XP Professional | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Server | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Professional | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Datacenter Server | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Solaris | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Advanced Server | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
64-bit Enabled Solaris | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
AIX | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
64-bit Enabled AIX | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
HP-UX IPF | 4.4 | 5.1 | | 9.1 TS1M3 SP4 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Topic: | System Administration ==> Servers
|
Date Modified: | 2007-08-23 14:19:27 |
Date Created: | 2007-08-23 14:19:27 |