Date: Fri, 22 May 2009 14:04:23 -0400
Reply-To: Nathaniel.Wooding@DOM.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject: Re: Deleting rows in a data set...help required
In-Reply-To: <16FD64291482A34F995D2AF14A5C932C07437DF0@MAIL002.prod.ds.russell.com>
Content-Type: text/plain; charset="US-ASCII"
I think that if you add
Array able _numeric_;
Do over able;
if able not in( 11 , 21 ) then flag = 1;
end;
if flag;
drop flag;
to my code, you fix the second half of the problem;
And for inquiring minds, the Do Over was an early SAS construct that was
dropped from the documention around V5 but still works.
Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
"Terjeson, Mark"
<Mterjeson@russel
l.com> To
"Joe Matise" <snoopy369@GMAIL.COM>,
05/22/2009 01:33 <SAS-L@LISTSERV.UGA.EDU>,
PM <Nathaniel.Wooding@DOM.COM>
cc
Subject
RE: Re: Deleting rows in a
data set...help required
Nicely done by the [Nat+Joe] tag-team.
Clever approach.
Mark
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe
Matise
Sent: Friday, May 22, 2009 10:29 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Deleting rows in a data set...help required
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.
>
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.
| 
