|Date: ||Thu, 7 Aug 2008 13:45:22 +0530|
|Reply-To: ||Madan Gopal Kundu <Madan.Kundu@RANBAXY.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Madan Gopal Kundu <Madan.Kundu@RANBAXY.COM>|
|Subject: ||Re: using proc sql|
|Content-Type: ||text/plain; charset="us-ascii"|
Here is the required code:
input a b;
create table des as select
count(*) as count, a,
group by b
Madan Gopal Kundu
Biostatistician, CDM, MACR, Ranbaxy Labs. Ltd.
Tel(O): +91 (0) 1245194045 - Mobile: +91 (0) 9868788406
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Thursday, August 07, 2008 1:21 PM
Subject: using proc sql
Here I have a situation where I have to delete some observations from
a dataset and have to pass the remaining observations into another
Here 30 is repeated for b. Now I want to delete both the rows
including 30 and pass the remaining all into another dataset.
The final dataset should be
Could anybody suggest a code in proc sql for this?
(i) The information contained in this e-mail message is intended only
for the confidential use of shashi2707@GMAIL.COM;SAS-L@LISTSERV.UGA.EDU.
This message is privileged and confidential. If the reader of this message
is not the intended recipient or an agent responsible for delivering it to the
intended recipient, you are hereby notified that you have received this
document in error and that any review, dissemination, distribution, or
copying of this message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and delete
the original message.
(ii) Madan.Kundu@ranbaxy.com confirms that Ranbaxy shall not be responsible if this
email message is used for any indecent, unsolicited or illegal purposes,
which are in violation of any existing laws and the same shall solely be
the responsibility of Madan.Kundu@ranbaxy.com and that Ranbaxy shall at all times be
indemnified of any civil and/ or criminal liabilities or consequences there.