Problem Note 2436: Long name support not enabled when generating a range of macros in the
SQL procedure
You cannot use long names for your macro variables when using the
dash (-) or the through (thru) keyword to imply a range of variables.
This syntax creates one macro variable per row in the result of the
SELECT statement. If the macro variable names are longer than 8
characters, you receive:
Warning: Apparent symbolic reference LONGMACRONAME not resolved.
where LONGMACRONAME is your macro variable name. For example, the
following syntax illustrates the problem:
proc sql;
reset noprint;
select var1 into :mylongmacroname1-:mylongmacroname10
from mylib.mydataset;
quit;
This problem is corrected in Release 8.1 TSLEVEL 1M0.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | Base SAS | Microsoft Windows 95/98 | 8 TS M0 | 8 TS M1 |
| Microsoft Windows NT Workstation | 8 TS M0 | 8 TS M1 |
| 64-bit Enabled Solaris | 8 TS M0 | 8 TS M1 |
| Solaris | 8 TS M0 | 8 TS M1 |
| OpenVMS VAX | 8 TS M0 | 8 TS M1 |
| IRIX | 8 TS M0 | 8 TS M1 |
| ABI+ for Intel Architecture | 8 TS M0 | 8 TS M1 |
| z/OS | 8 TS M0 | 8 TS M1 |
| OS/2 | 8 TS M0 | 8 TS M1 |
| HP-UX | 8 TS M0 | 8 TS M1 |
| OpenVMS Alpha | 8 TS M0 | 8 TS M1 |
| 64-bit Enabled HP-UX | 8 TS M0 | 8 TS M1 |
| CMS | 8 TS M0 | 8 TS M1 |
| Microsoft Windows 2000 Professional | 8 TS M0 | 8 TS M1 |
| 64-bit Enabled AIX | 8 TS M0 | 8 TS M1 |
| Tru64 UNIX | 8 TS M0 | 8 TS M1 |
| AIX | 8 TS M0 | 8 TS M1 |
*
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: | SAS Reference ==> Procedures ==> SQL
SAS Reference ==> SQL
|
| Date Modified: | 2000-04-12 15:07:20 |
| Date Created: | 2000-04-12 15:07:20 |
