Date:         Tue, 10 Apr 2012 17:57:59 -0400
Reply-To:     bbser 2009 <bbser2009@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         bbser 2009 <bbser2009@GMAIL.COM>
Subject:      Re: Missing
Comments: To: Val Krem <valkrem@yahoo.com>
In-Reply-To:  <1334094017.87570.YahooMailNeo@web125906.mail.ne1.yahoo.com>
Content-Type: text/plain; charset="ISO-8859-1"

How about a where statement?

Where yourvariable ne -9;

Regards, Max
(Maaxx)


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Val
Krem
Sent: April-10-12 5:40 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: [SAS-L] Missing

Hi all,


I  big data set containing several variable.  Some of the variables have
missing observation  represented by -9.

I want to calculate means of each variable by excluding the the missing
observations

I used proc means; var  x1 x2 x3 x4 x5;

Does proc means have option that exclude the missing observation?


Thanks  in advance