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
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.
2009/2/11 Mary <firstname.lastname@example.org>:
> 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.