Usage Note 8277: Error: Unresolved reference to table/correlation name xxxxx in PROC SQL
Possible reason(s) for this error to occur in PROC SQL are:
- misspelling of the table name, or the table ALIAS, when using
TABLE.COLUMN syntax on the SELECT statement, or in the WHERE,
GROUP BY, HAVING or ORDER BY clauses.
- using LIBREF.COLUMN name syntax in either the SELECT statement,
or in the WHERE, GROUP BY, HAVING or ORDER BY clauses. The
TABLE.COLUMN syntax should be used instead
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows NT Workstation | 8 TS M0 | |
| Microsoft Windows 2000 Server | 8 TS M0 | |
| Microsoft Windows 95/98 | 8 TS M0 | |
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | |
| Microsoft Windows 2000 Professional | 8 TS M0 | |
| Solaris | 8 TS M0 | |
| OpenVMS VAX | 8 TS M0 | |
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | |
| IRIX | 8 TS M0 | |
| 64-bit Enabled Solaris | 8 TS M0 | |
| z/OS | 8 TS M0 | |
| OS/2 | 8 TS M0 | |
| HP-UX | 8 TS M0 | |
| ABI+ for Intel Architecture | 8 TS M0 | |
| CMS | 8 TS M0 | |
| 64-bit Enabled AIX | 8 TS M0 | |
| 64-bit Enabled HP-UX | 8 TS M0 | |
| OpenVMS Alpha | 8 TS M0 | |
| Tru64 UNIX | 8 TS M0 | |
| AIX | 8 TS M0 | |
*
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: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> SQL SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2003-12-26 16:25:06 |
| Date Created: | 2002-08-15 14:47:04 |