topic close an opened table with open instruction in New SAS User

close an opened table with open instruction

Nasser_DRMCP — Tue, 27 Aug 2024 13:18:54 GMT

hello

data HAVE ;
x=1;
run ;

%let mv_id_table = %sysfunc(open(work.HAVE)); 

proc datasets library=WORK memtype=data nolist;
delete HAVE ;
quit ;

by executing this code, the note is "File WORK.HAVE (memtype=DATA) cannot be deleted because it is in use."

how could I close the HAVE table ?

thanks in advance for your help

regards

Nasser

Re: close an opened table with open instruction

SASJedi — Tue, 27 Aug 2024 13:22:35 GMT

Close the file before attempting to delete it:

%let rc= %sysfunc(close(&mv_id_table ));

Re: close an opened table with open instruction

Tom — Tue, 27 Aug 2024 13:23:46 GMT

When you open a DATASET (as opposed some generic FILE) with the OPEN() function it returns a reference to that dataset. So to close it you pass that reference back to the CLOSE() function.

%let rc=%sysfunc(close(&mv_id_table)) ;