Thanks for the compliment Mary.

Although Data _null_ is correct in that the program is wrong, I was simply trying to demonstrate "where augmentation" with Akshaya's code. I'm putting it down as a rookie mistake ;-)

The 'where also' is one of the many things that I learnt from this list after being fortunate enough to find the list pretty early on. I wrote my first SAS program on the 15th October 2007 and I think I posted my first question about a month and half later. At which point I was using macro's to do everything and I stored almost everything in global macro variables, but that was slapped out of me pretty quick on this list.

I think one of the best ways to learn, is searching SAS-L and reading old posts from BOF winners, you certainly pick up a lot of gems. The only problem is I have been a bit too busy recently.

Karma

2009/2/11 Mary <mlhoward@avalon.net>: > data _null_, > > Yes, I was referring to knowing "where also", but actually, > it doesn't produce the right results in this case, since it is > cumulative of the where clauses so far. > > But of course we do not expect rookies to know as much > as Most Valuable Persons do :-) > > -Mary (current SAS-L Rookie of the Year :-)) > p.s ...and data _null_ is the current MVS of the Year. > > > ----- Original Message ----- > From: ./ ADD NAME=Data _null_; > To: SAS-L@LISTSERV.UGA.EDU > Sent: Wednesday, February 11, 2009 11:26 AM > Subject: Re: Different WHERE statements for different variables? > > > I don't think Karma's program produces the correct output. At least > as I see it. > > Or where you referring to WHERE ALSO. >