sas base

[fatemeh]

Hello. I appreciate you help me find answer for the bellow question:

What statement removes the library reference from excel workbook?

[japelin · Accepted solution]

Is this what you mean?

/* assign library X to excel file */
libname x excel 'C:\Temp\temp.xlsx';

/* remove library X */
libname x;
/* or */
libname x clear;

[Reeza]

LIBNAME both assigns and clears the connection to DB, file or folder.