topic Default Saving of Table name in lower case in Administration and Deployment

Default Saving of Table name in lower case

Mushy — Tue, 26 Oct 2021 07:51:21 GMT

Hello,

When I create a table using DI studio irrespective of the Metadata name, the table is always created in lowercase in the linux server. May I know if anyone knows how to change this behavior to say, create the table in Upper case of mixed case?

Also in Enterprise Guide I always see the table name in Upper case. May the know the reason for this?

Thanks,

Mushy

Re: Default Saving of Table name in lower case

Kurt_Bremser — Tue, 26 Oct 2021 07:57:42 GMT

.sas7bdat files MUST be all lowercase, period. If any character is uppercase on case sensitive systems (read UNIX), the file becomes unusable.

The internal representation (e.g. in the DICTIONARY tables) is always uppercase; this comes from the initial mainframe environment on which SAS was initially developed.

These behaviors cannot be changed.

Re: Default Saving of Table name in lower case

Patrick — Tue, 26 Oct 2021 07:59:37 GMT

Table names in SAS aren't case sensitive but files under Unix/Linux. So what should "SAS" do if there are two .sas7bdat files in a folder where the names only differ in the casing (which under Unix/Linux is possible).

It makes to me a lot of sense that SAS stores all tables physically in lowercase only and that there isn't an option to change this behavior - as it would only be a recipe for a big mess.

SAS table names in the SAS data dictionary are stored in upper case. I guess it's upper case as that's been the "standard" casing in Mainframe environments. I guess EG just shows the names as per data dictionary.