I refer to ODBC libraries using the following statement LIBNAME STATIC ODBC DATASRC = static SCHEMA = DBO USER = <username> PASSWORD = <password>; I am trying to create a new table within the the Static table in SQL Server using the following code: proc sql; create table static.NEW_SQL_TABLE as select * from static.OLD_SQL_TABLE (obs = 10); quit; I get the following error --> ERROR: CLI Execute Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'DBO.NEW_SQL_TABLE'. :[Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared. However a simple temporary dataset within SAS works perfectly fine using the below code: proc sql; create table TEMP_SQL_TABLE as select * from static.OLD_SQL_TABLE (obs = 10); quit; Can anybody please help me with this? How else will I be able to directly write a SAS dataset into the SQL database (without having to export to csv and then importing back again, which is what I currently do -pardon my ignorance here)? Thanks a ton. ... View more