librefs character resctrictions and sql schema

[altoz]

Hi All,

sql schema of my table longer than 8 characters and so i take the error that librefs are restricted to eight characters.

proc sql;

SELECT * FROM RISKYONETIMI.OA_20201015_DENEME (OBS=3);

quit;

I can't change the name of this schema. Can i solve this problem?

[Kurt_Bremser]

To use SAS code on a DBMS table, you need to define a library pointing to the DB schema. While the name of that library is restricted to 8 characters, the schema name in the connection options of the LIBNAME statement can be anything your DBMS allows. In your SAS code, use the SAS library name.

If you do explicit passthrough, you can use any code that is valid in the DBMS.