LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2012, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 24 Feb 2012 08:51:04 -0500
Reply-To:   Tom Abernathy <tom.abernathy@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Tom Abernathy <tom.abernathy@GMAIL.COM>
Subject:   Re: Differentiating between missing values (Continuous variable)

You will need to do the summary in two steps to get both types of information. If your data is really large and you do not want to read it twice try creating a view that creates new variables that you can use to count the different missing values.

data x / view=x; set have ; nmiss = x=. ; nnd = x=.n ; run; proc summary data=x ; var x nmiss nnd; output out=want sum(nmiss)=nmiss sum(nnd)=nnd ..... ; run;

On Fri, 24 Feb 2012 07:00:57 -0500, anon <rhian.pilling@GMAIL.COM> wrote:

>Dear all, > >I am still struggling with my previous post. > >I am trying to output summary statistics for a CONTINUOUS variable - >specifically the median, IQR, total observations, complete observations, >those not done (.n) and missing (.) > >However, my issue is is that not done (.n) and missing (.) are continually >being combined and being output as a combined missing (.n + .) whatever >procedure I use.I have used proc means looked and tried proc freq, proc >univariate and proc tabulate. > >Does anyone know how I can differentiate between these missing values in SAS >without categorising the variable (if I categorise I lose the correct median >/IQR values). > >Ultimately I am putting all summary statistics into proc report. > >BW


Back to: Top of message | Previous page | Main SAS-L page