- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-08-2011 04:05 AM
(19036 views)
how to delete a sas library permanently
15 REPLIES 15
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Scott Barry
SBBWorks, Inc.
Google advanced search argument, this topic / post:
delete sas library site:sas.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
So please help me on this topic .
How we can delete a sas dataset permanently.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello Arpit,
Highlight a dataset name in a SAS library and press Delete or do the same thing in Windows folder (;-)
Sincerely,
SPR
Highlight a dataset name in a SAS library and press Delete or do the same thing in Windows folder (;-)
Sincerely,
SPR
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you want to delete all the members in a sas library, use
[pre]
proc datasets lib= kill;
[/pre]
[pre]
proc datasets lib=
[/pre]
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Dear Poligjw,
It delete only content of library .
I want to know how to delete complit library
Thanks for your kind information.
It delete only content of library .
I want to know how to delete complit library
Thanks for your kind information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
have you tried
LIBNAME lib ;
LIBNAME lib ;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Dear Sbb,
Thanks for your information Could you explain .
Regards,
Arpit
Thanks for your information Could you explain .
Regards,
Arpit
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Yes i try with this statement but it delete the file of library
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
sorry, I thought that was what you wanted..
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Scott Barry
SBBWorks, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
'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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
You can delete a library which you have created using Libname statement.
The command is libname
You can't delete SAS peramanent libraries like sasuser, sashelp, maps.
I hope this is what you want.
Regards,
Manoj Khandelwal
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 .
🙂