Well Howard got a hold of me earlier, I just haven't had a chance to respond. Actually I almost never use the Means procedure so I wasn't wholly sure if I could use the NWay option with it as I do with the Proc Summary. Thus, it was my lack of knowledge of the Means procedure options that kead to me doing it that way. Upon looking at the online docs (should have looked it up before hitting send) the NWay option is the way to go instead of the Where Data Set option.

Toby Dunn

"I'm a hell bent 100% Texan til I die"

"Don't touch my Willie, I don't know you that well"

> Date: Thu, 21 Oct 2010 09:28:04 -0500 > From: iebupdte@GMAIL.COM > Subject: Re: Saving the sub-means > To: SAS-L@LISTSERV.UGA.EDU > > On Thu, Oct 21, 2010 at 8:52 AM, toby dunn <tobydunn@hotmail.com> wrote: > > The proper way to do the Mean Procedure, I stuck with the Class statement because one doesn't have to have it sorted like in the previous Data Step Statement. > > However, that means I had to use the Where data step option on the resulting data set.: > > > > Proc Means > > Data = Psy NoPrint ; > > Class Student_Id ; > > Var Hours GPA ; > > ID ACT ; > > OutPut Out = Need3 ( Drop = _Type_ _Freq_ > > Where = ( Not Missing( Student_ID ) ) ) > > Mean = Hours_mean GPA_mean ; > > Run ; > > Can you explain this a bit more for us commoners. What is different > about MEANS that a WHERE data set option is needed? Couldn't you use > virtually then same syntax for either MEANS or SUMMARY, e.g. NWAY.