What's wrong with this script ? it work fine on the production server but not on the development server even if the tables exist.
proc sql;
create table test as
select contractVer.*
from cntrctDM.DIM_PL_CNTRCT_VER contractVer ;
quit;
ERROR: CLI prepare error: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a
qualified name.SQL statement: SELECT * FROM CONTRACTPL_DM.DIM_PL_CNTRCT_VER.