topic How i delete physical data from sas data set which was already deleted logically ? in SAS Programming

How i delete physical data from sas data set which was already deleted logically ?

MG18 — Fri, 30 Dec 2016 04:53:07 GMT

I have been deleting records logically from one dataset , when i checked size of dataset is remains always same after deletion of records also .

Query used :-

proc sql;

delete from ADFBASE.advdep_final_sas1;

quit;

Result :-

NOTE: 57589 rows were deleted from ADFBASE.ADVDEP_FINAL_SAS1.

But when i checked size of ADFBASE.ADVDEP_FINAL_SAS1 in server , it is still same after deletion of 57589 records.

we are using same code for many dataset and it is just deleting data only Logically not physically.

I want to delete the records which are already deleted so that it will free size for that dataset.

How to delete records which were already deleted logically ?

Reeza — Fri, 30 Dec 2016 04:54:13 GMT

Do you want to delete all records or remove the table entirely?

MG18 — Fri, 30 Dec 2016 06:15:45 GMT

I want to remove some records physically which is already removed from dataset using below query:-

proc sql ;

delete from advdep_final_sas1;

quit;

after using above query the size of datset remains same that means it is not deleting records from dataset physically.

How to remove records from dataset which was deleted previouslly ?

Shmuel — Fri, 30 Dec 2016 06:22:42 GMT

you need just copy it to itself:

data ADFBASE.ADVDEP_FINAL_SAS1;

set ADFBASE.ADVDEP_FINAL_SAS1;

run;

the logical deleted observations will not be copied.