03-27-2012 12:24 PM
When I use PROC SQL; DELETE FROM TABLE; i see that sas file is constantly increasing. How can I enforce (with some option perhaps) to delete recordes permanently and free the disk space?
03-27-2012 12:34 PM
I am not sure if this is relevant: if I use system options compress=yes, and then after I delete some records, the file size remains the same, unless you invoke another system option: reuse=yes.
So it would look like this:
What it does is to reuse those vacant slots from deleted records instead of appending to the end.
BTW, these two options are also data set options as well.
03-28-2012 02:57 AM
I don't understand what you mean.
If you want delete a table ,then use DROP TABLE
If you want keep the constructure of a table ,then use CREAT TABLE xx LIKE xx, then drop the original table.
03-28-2012 04:21 AM
I've got table T1.
When I delete all record from it (Proc sql; Delete from T1 the table size doesn't decrease. Moreover, when I put some records in this table I see that record number shows as If there were some "invisible records" inside. System seems to keep deleted record which take disk space and when iserting new records the table size is contantly growing..
03-28-2012 07:20 AM
You seem to have figured out how SAS works when you delete records without recreating the dataset. If it is a concern to you then recreate the dataset. (data old; set old; run