Date:         Mon, 25 Jul 2011 10:56:20 -0400
Reply-To:     "Viel, Kevin" <kviel@SJHA.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Viel, Kevin" <kviel@SJHA.ORG>
Subject:      Re: MDX query & missing value information
In-Reply-To:  <201107240941.p6NAxP0u028577@willow.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

> -----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 we
> 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 "--"

Sagar,

  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.

HTH,

Kevin



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
kviel@sjha.org
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.