Date:         Thu, 25 Mar 2010 12:04:39 +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: Reading Data
Comments: To: chittiprolu pradeep <chittiprolupradeep@gmail.com>
In-Reply-To:  <3548630b1003250208m4d7dcb10u886a798db281a79c@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

HI,
I hope it helps you (it deletes one by one, not 'together'):

%let BBC_datasets=
BBC_cor_STG1
BBC_dor_STG1
BBC_for_STG1
BBC_bor_STG1
BBC_kor_STG1;

 Data _null_;
 do y=1 to 5; * 5 datasets;
 a=scan("&BBC_datasets",y,'');
 b='data '||A||'; set '||A||'; if period="FEB2010" then delete;run;';
 call execute(b);
 end;
 run;

Daniel Fernandez.
Barcelona.

2010/3/25 chittiprolu pradeep <chittiprolupradeep@gmail.com>:
> Hi All,
>
> I have 5 sas datasets which are names as below:
> BBC_cor_STG1
> BBC_dor-STG1
> BBC_for_STG1
>  BBC_bor_STG1
>  BBC_kor_STG1
>
> all these sas datasets contains 'Period' variable. And now i looking to
> delete those observations which period have 'FEB2010'. In this period
> variable
> there will all the months... like Dec2009, Jan2010, Feb2010.... and i need
> to delete those observations where period is Feb2010.
>
> But i need to delete for all the above datasets together. Can any one can
> help me in dis please...
>
>
> Thanks
>