The TRUNCATE
command is a PROC SPDO command that allows you to delete all of the
rows in a table without deleting the table structure or metadata.
%let host=kaboom;
%let port=5191;
%let domain=path2;
LIBNAME &domain sasspds "&domain"
server=&host&port
user='anonymous'
ip=YES;
/* create a table */
DATA &domain..staceys_table;
do i = 1 to 100;
output;
end;
run;
/* verify the contents of the created table */
PROC CONTENTS data=&domain..staceys_table ;
run;
/* SPDO Truncate command deletes the table */
/* data but leaves the table structure in */
/* place so new data can be appended */
PROC SPDO lib=&domain;
SET acluser;
TRUNCATE staceys_table;
quit;
/* verify that no rows or data remain in */
/* the structure of staceys_table */
PROC CONTENTS data=&domain..staceys_table;
run;