topic librefs character resctrictions and sql schema in New SAS User

librefs character resctrictions and sql schema

altoz — Thu, 15 Oct 2020 07:11:25 GMT

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?

Re: librefs character resctrictions and sql schema

Kurt_Bremser — Thu, 15 Oct 2020 07:25:44 GMT

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.