Date: Mon, 25 Jul 2011 22:34:39 +0530
Reply-To: "sagar.s" <sagar.s@SATVIKINC.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "sagar.s" <sagar.s@SATVIKINC.COM>
Subject: Re: MDX query & missing value information
Content-Type: text/plain; charset=ISO-8859-1
I just want to know like
1) Pivot Table there is any option for ROW-TOTAL, COl-TOTAL and GRAND-TOTAL
in MDX query.
2) For Missing Value I have Numeric Missing value dot, I want to is there
any option which will represents missing value
in different character. Like in Oracal You can use NVL option for different
representation of missing value.
On Mon, Jul 25, 2011 at 8:26 PM, Viel, Kevin <email@example.com> wrote:
> > -----Original Message-----
> > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> > "SUBSCRIBE SAS-L sagar".
> > Sent: Sunday, July 24, 2011 5:41 AM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: MDX query & missing value information
> > Hi,
> > Suppose I am running a MDX query after that I will get the result in
> > Dataset
> > format. If there is any option in MDX query I will get the ROWTOTAL &
> > COLTOTAL
> > as well.
> > 2nd thing
> > Suppose I Have a dataset all values are numeric. This a dynamic dataset
> > dont know about no of column & Row . The missing value represented by .
> > Is any comment in sql wehen we are pulling the data we can replace the
> > . with '--' or
> > after getting the dataset can we replace all . by "--"
> You might want to clarify MDX query, ROWTOTAL, and COLTOTAL. The query
> seemed to put your data into a SAS dataset. If you describe your data, I am
> sure we can help you get a ROWTOTAL and a COLTOTAL.
> "." in SAS is how numeric values are stored. You can use a FORMAT to
> affect how is displayed. Where do you want to see "." replaced by "--"?
> The fact that you have missing values is important to how you want to
> calculate the totals.
> Kevin Viel, PhD
> Senior Research Statistician
> Patient Safety & Quality
> International College of Robotic Surgery
> Saint Joseph's Translational Research Institute
> Saint Joseph's Hospital
> 5671 Peachtree Dunwoody Road, NE, Suite 330
> Atlanta, GA 30342
> (678) 843-6076: Direct Phone
> (678) 843-6153: Facsimile
> (404) 558-1364: Mobile
> Confidentiality Notice:
> This e-mail, including any attachments is the
> property of Catholic Health East and is intended
> for the sole use of the intended recipient(s).
> It may contain information that is privileged and
> confidential. Any unauthorized review, use,
> disclosure, or distribution is prohibited. If you are
> not the intended recipient, please delete this message, and
> reply to the sender regarding the error in a separate email.