Date:         Thu, 28 Jan 2010 18:33:23 +0100
Reply-To:     Daniel Fernández <fdezdan@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Fernández <fdezdan@GMAIL.COM>
Subject:      Re: Delete Datasets - More than one
Comments: To: Gerhard Hellriegel <gerhard.hellriegel@t-online.de>
In-Reply-To:  <201001281712.o0SBkf0o004499@malibu.cc.uga.edu>
Content-Type: text/plain; charset=windows-1252

Perhaps, if you only need a few ones  (example: final_summary dataset)
, you can try:

proc datasets lib=work;
save final_summary ;
run;

It will delete all but 'final_summary' dataset.


Daniel Fernandez.
barcelona.



2010/1/28 Gerhard Hellriegel <gerhard.hellriegel@t-online.de>:
> try:
>
> proc datasets lib=work;
>    delete week_:;
> run;
>
> Gerhard
>
>
>
>
> On Thu, 28 Jan 2010 12:05:31 -0500, SAS Swamy <sasswamy@GMAIL.COM> wrote:
>
>>Hello,
>>
>>I have to delete bunch of data sets from the WORK library , before
>>starting the next Iteration from the Loop ,
>>
>>I know the following some of the ways to delete single data sets :
>>PROC DATASETS NOLIST LIBRARY = WORK; DELETE week_1; QUIT;
>>Or we can use PROC SQL ,  drop table week_0 ….
>>
>>I am having data sets like week_0 …… week_25 …etc , which might be
>>changing for each Iteration ,
>>
>>Can someone tell me how to delete all the data sets beginning with week_
>>
>>Thanks
>>swamy
>