topic Re: how to delete a library permanently in SAS Programming

how to delete a library permanently

arpit — Tue, 08 Mar 2011 09:05:13 GMT

how to delete a sas library permanently

Re: how to delete a library permanently

sbb — Tue, 08 Mar 2011 13:52:05 GMT

A straightforward SAS support SEARCH request (or Google advanced) reveals several relevant references.

Scott Barry
SBBWorks, Inc.

Google advanced search argument, this topic / post:
delete sas library site:sas.com

Re: how to delete a library permanently

Doc_Duke — Tue, 08 Mar 2011 15:57:41 GMT

'permanently' is subject to multiple interpretations. The search items that Scott provided can generally be used to delete a library 'reference' in a SAS programming environment.

In Unix and Windows, a library refers to a physical directory on disk. To "permanently" remove the directory and it's data requires a third party utility. For instance, "File Shredder" ( http://www.fileshredder.org/ ) will over-write the bits in Windows.

Doc Muhlbaier
Duke

Re: how to delete a library permanently

arpit — Tue, 08 Mar 2011 16:10:17 GMT

Thanks for your kind information .But I go through google i couldn't find this.

So please help me on this topic .

How we can delete a sas dataset permanently.

Re: how to delete a library permanently

SPR — Tue, 08 Mar 2011 16:27:26 GMT

Hello Arpit,

Highlight a dataset name in a SAS library and press Delete or do the same thing in Windows folder (;-)

Sincerely,
SPR

Re: how to delete a library permanently

polingjw — Tue, 08 Mar 2011 16:33:33 GMT

If you want to delete all the members in a sas library, use
[pre]
proc datasets lib= kill;
[/pre]

Re: how to delete a library permanently

arpit — Wed, 09 Mar 2011 05:25:01 GMT

Dear Poligjw,

It delete only content of library .

I want to know how to delete complit library

Thanks for your kind information.

Re: how to delete a library permanently

Peter_C — Wed, 09 Mar 2011 13:09:31 GMT

have you tried
LIBNAME lib ;

Re: how to delete a library permanently

sbb — Wed, 09 Mar 2011 14:22:14 GMT

The technical method / process will depend on your SAS OS environment.

So, for Windows, consider using PROC DATASETS with KILL to clear the SAS library of all members followed by using the FDELETE function (either in a DATA step or with SYSFUNC using SAS macro language) to remove/delete an empty directory (or external file reference).

Scott Barry
SBBWorks, Inc.

Re: how to delete a library permanently

arpit — Thu, 10 Mar 2011 05:10:21 GMT

Dear Sbb,

Thanks for your information Could you explain .

Regards,
Arpit

Re: how to delete a library permanently

arpit — Thu, 10 Mar 2011 05:11:33 GMT

Yes i try with this statement but it delete the file of library

Re: how to delete a library permanently

Peter_C — Thu, 10 Mar 2011 09:14:42 GMT

sorry, I thought that was what you wanted..

Re: how to delete a library permanently

sbb — Thu, 10 Mar 2011 13:24:20 GMT

Suggest the OP read the available SAS DOC and also consider the SAS support http://support.sas.com/ website resources -- consider the recommended search arguments provided in a prior post-reply.

Scott Barry
SBBWorks, Inc.

Re: how to delete a library permanently

MKhandelwal — Mon, 02 May 2011 07:38:44 GMT

Hi Arpit,

You can delete a library which you have created using Libname statement.
The command is libname clear;
You can't delete SAS peramanent libraries like sasuser, sashelp, maps.

I hope this is what you want.

Regards,
Manoj Khandelwal

Re: how to delete a library permanently

sas247 — Wed, 03 Aug 2016 21:26:04 GMT

Yes, that's correct .You can use

libname mylib clear;

mylib- is the library you like to delete.

the entire library with its contents will be deleted.

It is one of the house keeping practices .

🙂

Re: how to delete a library permanently

SuryaKiran — Thu, 04 Aug 2016 00:49:33 GMT

LIBNAME mylib CLEAR; This statement only deassign

In Log you can see NOTE: Libref mylib has been deassigned.