Im checking my datasets and a way to shrink them to retrieve some space, and i saw that after deleting millions of rows from some datasets using proc sql; delete; the datasets keeps the size on the server file, and i saw in the dictionary table that there is column named delrows where you have all the data deleted "logically" from the dataset, but not from the file:
![pdiaz_0-1665397536367.png pdiaz_0-1665397536367.png](https://communities.sas.com/t5/image/serverpage/image-id/76048i1E28C40EBEFFBC96/image-size/medium?v=v2&px=400)
this is a sample of some tables with a lot of rows that are deleted from the dataset but keep, i supose logically in there, like a windows delete i supose there would be a "defragmentation" of the table to phisically delete this registers, but i didn't found anything on the kb to proceed with it, is there a way to permanently remove this rows and regain the space at administration level?
Or am i forced to do a DATA / SET step to recreate the table?
Thanks!