Reduce size table

[jorquec]

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;

[tomrvincent · Accepted solution]

your code will delete all records. Use compress to lower the size (not guaranteed).

[jorquec]

Compress?
How?
proc sql;
delete from sasmf.TRIGGERPAYTEST;
compress;
quit;

[Tom]

All you did was mark the observations as deleted.

Why not just re-create the dataset?

[jorquec]

Sorry I can not re create the file because I lost the rights . My only option is change the size.

[SASKiwi]

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?

[Ksharp]

data sasmf.TRIGGERPAYTEST;
 set sasmf.TRIGGERPAYTEST;
 stop;
run;