Problem Note 46193: A warning occurs when you use a range of macro variables in the SQL procedure and the case of those variable names is not the same
In the SQL procedure (PROC), the SELECT statement's INTO clause is case-sensitive. Consequently, when you use a range of macro variables in the INTO clause and those variable names have inconsistent casing, a warning similar to the following occurs:
select name into :mvar1 - :Mvar20
WARNING: INTO Clause :mvar1 thru :Mvar20 does not specify a valid sequence of macro variables.
Operating System and Release Information
SAS System | Base SAS | IRIX | | 9.4 TS1M0 |
AIX | | 9.4 TS1M0 |
HP-UX | | 9.4 TS1M0 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | | 9.4 TS1M0 |
Microsoft Windows XP 64-bit Edition | | 9.4 TS1M0 |
Microsoft® Windows® for x64 | | 9.4 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | | 9.4 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | | 9.4 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | | 9.4 TS1M0 |
Microsoft Windows Server 2003 for x64 | | 9.4 TS1M0 |
ABI+ for Intel Architecture | | 9.4 TS1M0 |
64-bit Enabled Solaris | | 9.4 TS1M0 |
HP-UX IPF | | 9.4 TS1M0 |
64-bit Enabled HP-UX | | 9.4 TS1M0 |
Windows Vista for x64 | | 9.4 TS1M0 |
64-bit Enabled AIX | | 9.4 TS1M0 |
Windows Vista | | 9.4 TS1M0 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | | 9.4 TS1M0 |
Microsoft Windows Server 2008 | | 9.4 TS1M0 |
Microsoft Windows Server 2008 for x64 | | 9.4 TS1M0 |
Microsoft Windows XP Professional | | 9.4 TS1M0 |
Tru64 UNIX | | 9.4 TS1M0 |
Solaris for x64 | | 9.4 TS1M0 |
Solaris | | 9.4 TS1M0 |
OpenVMS on HP Integrity | | 9.4 TS1M0 |
OpenVMS Alpha | | 9.4 TS1M0 |
Linux on Itanium | | 9.4 TS1M0 |
Linux for x64 | | 9.4 TS1M0 |
Linux | | 9.4 TS1M0 |
DB2 Universal Database on AIX | | 9.4 TS1M0 |
DB2 Universal Database on Linux x64 | | 9.4 TS1M0 |
Greenplum on Linux x64 | | 9.4 TS1M0 |
Netezza TwinFin 32bit blade | | 9.4 TS1M0 |
Netezza TwinFin 32-bit SMP Hosts | | 9.4 TS1M0 |
Netezza TwinFin 64-bit S-Blades | | 9.4 TS1M0 |
Netezza TwinFin 64-bit SMP Hosts | | 9.4 TS1M0 |
Teradata on Linux | | 9.4 TS1M0 |
z/OS | | 9.4 TS1M0 |
Z64 | | 9.4 TS1M0 |
OpenVMS VAX | | 9.4 TS1M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | | 9.4 TS1M0 |
Aster Data nCluster on Linux x64 | | 9.4 TS1M0 |
*
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: | medium |
Date Modified: | 2012-06-08 14:56:27 |
Date Created: | 2012-04-02 11:11:45 |