Hi,
Could anyone please help?
It is a simple code to delete rows from a sas table, however my objective with this is to decrease the size of table because I will use the size later as a schedule on SAS Management.
However despite of this code delete rows the size table keeps always the same .
Many thanks in advance .
proc sql;
delete from sasmf.TRIGGERPAYTEST;
quit;
All you did was mark the observations as deleted.
Why not just re-create the dataset?
Sorry I can not re create the file because I lost the rights . My only option is change the size.
Using this DATA step with the COMPRESS option will compress your dataset and remove all rows:
data sasmf.TRIGGERPAYTEST (compress = yes);
sasmf.TRIGGERPAYTEST (obs= 0);
run;
BTW does sasmf mean this a mainframe SAS data library? What OS does SAS run on?
data sasmf.TRIGGERPAYTEST;
set sasmf.TRIGGERPAYTEST;
stop;
run;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.