SUPPORT / SAMPLES & SAS NOTES
Problem Note 47109: SAS® Enterprise Guide® tasks that are used with case-sensitive table names might result in an error
 |  |  |  |  |
Certain databases, such as Oracle, allow case-sensitive table names. To access tables with mixed-case names, you can use the PRESERVE_TAB_NAMES=YES option on a library.
However, using table names that contain lowercase characters with SAS Enterprise Guide tasks could result in an error. The error occurs because the generated code references the table by using all uppercase characters.
For example, below is the generated code from the One-Way Frequencies task:
PROC FREQ DATA=ORALIB.AAA
ORDER=INTERNAL
;
TABLES PFREE / SCORES=TABLE;
RUN;
/* -------------------------------------------------------------------
End of task code.
------------------------------------------------------------------- */
RUN; QUIT;
TITLE; FOOTNOTE;
Table "aaa" exists in the Oralib library, but table "AAA" does not. Therefore, the above code produces the following error:
ERROR: ORALIB.AAA does not exist.
As a workaround, copy the generated code into a program node and manually change the table name.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.2 TS2M3 | ||