SAS\Access sqlsvr connecting to Unix MS SQL database containing views with column names exceeding 32 characters in length. My reading indicates that SAS can overcome the 32 characters restriction by specifying in the LIBNAME statement the PRESERVE_COL_NAMES option. I've tried =YES as well as =NO and each results in ERROR 65-58: Name '. . . XYZ . . .' is too long for a SAS name in this context. Any helpful tips to resolve is appreciated.
... View more