https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809335#M319149 LIBNAME both assigns and clears the connection to DB, file or folder. Fri, 22 Apr 2022 15:23:01 GMT Reeza 2022-04-22T15:23:01Z https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809199#M319081 <P>Hello. I appreciate you help me find answer for the bellow question:</P><P>&nbsp;</P><P>What statement removes the library reference from excel workbook?</P> Fri, 22 Apr 2022 05:16:38 GMT https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809199#M319081 fatemeh 2022-04-22T05:16:38Z https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809200#M319082 <P>Is this what you mean?</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">/* assign library X to excel file */ libname x excel 'C:\Temp\temp.xlsx'; /* remove library X */ libname x; /* or */ libname x clear; </CODE></PRE> Fri, 22 Apr 2022 05:24:11 GMT https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809200#M319082 japelin 2022-04-22T05:24:11Z https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809335#M319149 LIBNAME both assigns and clears the connection to DB, file or folder. Fri, 22 Apr 2022 15:23:01 GMT https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809335#M319149 Reeza 2022-04-22T15:23:01Z