Date: Fri, 22 May 2009 12:29:10 -0500
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: Deleting rows in a data set...help required
In-Reply-To: <200905221720.n4MAnvjA002851@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1
You can accomodate that by adding:
if max(of id:) = 21 and min(of id:) = 12 then delete;
since 11 is smaller and 22 is higher than those.
-Joe
On Fri, May 22, 2009 at 12:20 PM, Gerhard Hellriegel <
gerhard.hellriegel@t-online.de> wrote:
> ...but you won't get out the 12 / 21 rows with that.
> Gerhard
>
>
> On Fri, 22 May 2009 13:10:04 -0400, Nat Wooding
> <Nathaniel.Wooding@DOM.COM> wrote:
>
> >Dinesh
> >
> >Here, we can use the max and min functions and the SAS automatic variable
> >_numeric_ which refers to all of the numeric variables in a data set.
> >
> >Data D;
> >input id1 id2 id3 id4 ;
> >cards;
> > 11 12 22 11
> > 22 11 12 12
> > 11 11 11 11
> > 12 21 12 21
> > 11 22 12 12
> > 12 21 22 11
> > 11 22 22 22
> > 22 22 22 22
> > 12 21 22 11
> > 11 22 11 21
> > run;
> > Data Wanted;
> > set D;
> > if max(of _numeric_) = min( of _numeric_) then delete;
> >run;
> >proc print;
> >run;
> >
> >Nat Wooding
> >Environmental Specialist III
> >Dominion, Environmental Biology
> >4111 Castlewood Rd
> >Richmond, VA 23234
> >Phone:804-271-5313, Fax: 804-271-2977
> >
> >
> >
> > Dinesh
> > <mtdinesh@GMAIL.C
> > OM> To
> > Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
> > Discussion" cc
> > <SAS-L@LISTSERV.U
> > GA.EDU>
> Subject
> > Deleting rows in a data set...help
> > required
> > 05/22/2009 12:21
> > PM
> >
> >
> > Please respond to
> > Dinesh
> > <mtdinesh@GMAIL.C
> > OM>
> >
> >
> >
> >
> >
> >
> >Dear All,
> >
> >I have some problems with my analysis..
> >
> >I have a data set with around 2000 columns and 50000 rows....
> >
> >the dataset appears like this...
> >
> > id1 id2 id3 id4---------
> >1 11 12 22 11
> >2 22 11 12 12
> >3 11 11 11 11
> >4 12 21 12 21
> >5 11 22 12 12
> >6 12 21 22 11
> >7 11 22 22 22
> >8 22 22 22 22
> >9 12 21 22 11
> >10 11 22 11 21
> >-
> >-
> >-
> >-
> >
> >Now..what i need is that, if a particular row contain same values
> >throughout the 2000 columns i want to delete it.
> >So if a row contains all 11 or all 22 or all 12 or all 21 it should be
> >deleted... also 12 and 21 are same and if a row contains only 12 and
> >21 it can also be deleted...
> >
> >so the final output will appear like
> >
> > id1 id2 id3 id4------
> >1 11 12 22 11
> >2 22 11 12 12
> >5 11 22 12 12
> >6 12 21 22 11
> >7 11 22 22 22
> >9 12 21 22 11
> >10 11 22 11 21
> >-
> >-
> >-
> >-
> >
> >rows 3 , 4 and 8 should be deleted...
> >
> >
> >Please help me to solve this
> >
> >Thanks
> >
> >Dinu
> >
> >
> >CONFIDENTIALITY NOTICE: This electronic message contains
> >information which may be legally confidential and or privileged and
> >does not in any case represent a firm ENERGY COMMODITY bid or offer
> >relating thereto which binds the sender without an additional
> >express written confirmation to that effect. The information is
> >intended solely for the individual or entity named above and access
> >by anyone else is unauthorized. If you are not the intended
> >recipient, any disclosure, copying, distribution, or use of the
> >contents of this information is prohibited and may be unlawful. If
> >you have received this electronic transmission in error, please
> >reply immediately to the sender that you have received the message
> >in error, and delete it. Thank you.
>
| 
