truncate table in sas proc sql?Advertisement
Here is a way to quickly remove the rows from a SQL Server table, using SAS/ACCESS Interface to ODBC. This does not remove the table from the database. It merely removes the rows of data from the table. proc sql; connect to odbc(dsn=SQLServer - read more
SAS' Proc SQL does not support the Truncate statement. Ideally, ... Recently I did a project and moved the TRUNCATE TABLE statements into a Stored Procedure to avoid the penalty of having them inside SAS and being handled by their SQL Optimizer and surrounding execution shell. - read more
Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or check other resources.