Reserved Language Keywords

To use SQL language reserved keywords as table or column names, you must identify them in the program syntax. When using the LIBNAME engine, use the LIBNAME statement options PRESERVE_TAB_NAMES=YES or PRESERVE_COL_NAMES=YES in the LIBNAME statement.

SQL reserved keywords include, for example, ANALYZE, CREATE, MEMBER, SELECT, and WHERE.

To use SELECT as a table name when using the LIBNAME engine, specify the PRESERVE_TAB_NAMES=YES option.

libname mylib fedsvr server="d1234.us.company.com" 
    port=2171 uid="myid" pwd="mypwd"
    dsn=oradsn preserve_tab_names=yes preserve_col_names=yes;

proc sql;
   create table mylib.select (row INT);
   insert into mylib.select values (100);
   select row from mylib.select;
quit;