Date: Thu, 17 May 2007 09:29:40 -0400
Reply-To: sanjay sun <sanjaysum@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: sanjay sun <sanjaysum@GMAIL.COM>
Subject: Re: format Pvalue6.4
In-Reply-To: <83ceb37a0705161339h3404ec1cq89ba9b7c49009b97@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi David,
I was trying to summarize data related to a questionnaire between two
treatment groups. I have to summarize data with p-value and C.I from
Wilcoxon rank sum test.I think (I am not a statistician) Getting such a low
p-value is can be attributed to the poor variability among any one treatment
group (see the SD) .
I have to present data in the following format
--------------------------------------------------------------------------------------------------------------------------------------
Group1 NS->B2000 (N=104)
p-value
Question Week
4 Week 4 Mean (95% CI)
--------------------------------------------------------------------------------------------------------------------------------------
1. XXXXXXXXXXXXXXXXXXXXXXX
1.0 (0.4,1.6) 0.0022
n
207 103 .
Mean (SD) 4.2(
2.66) 5.2 (2.83) .
Median
4.0 6.0 .
Min - Max 0
- 10 0 - 10 .
2. XXXXXXXXXXXXXXXXXXXXXX
1.9 (1.2,2.6) <.0001
.
n
206 103 .
Mean (SD) 3.6(
3.00) 5.5 (3.18) .
Median
3.0 6.0 .
Min - Max 0
- 10 0 - 10 .
3. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
0.3 (-0.4,1.0) 0.5791
the device?
.
n
207 102 .
Mean (SD) 2.9(
2.95) 3.2 (3.19) .
Median
2.0 2.0 .
Min - Max 0
- 10 0 - 10 .
4. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1.4 (0.8,2.1) <.0001
n
207 103 .
Mean (SD) 2.6(
2.68) 4.0 (2.88) .
Median
2.0 3.0 .
Min - Max 0
- 10 0 - 10 .
5. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
0.7 (0.1,1.4) 0.0005
n
207 103 .
Mean (SD) 1.9(
2.73) 2.7 (2.49) .
Median
1.0 2.0 .
Min - Max 0
- 10 0 - 9
I used format=pvalue6.4 in my proc report to format the p-value as they are
now. Everything went well except that I got a '.' whenever p-value column
was not having a value. I am sure there must be a way to resolve this but I
don't know what it is.
Thank u all for your time
On 5/16/07, sanjay sun <sanjaysum@gmail.com> wrote:
>
> Hi Group,
>
> I have this 'final' data set which has a variable called pvalue . It has
> the following values
>
> pvalue
>
> 0.003496
>
> 0.000001697
>
> 0.660355
>
> 0.000012689
>
> While using proc report I used format=pvalue6.4. But the problem is I am
> getting '.' in my final report whenever there is no value for a particular
> row in the final data set. How can I avoid this '>' in my final data set? I
> appreciate your help.
>
> Thnaks
>
> Sanjay
>
Let me ask a different question.
Why do you have a table of p-values?
And *why* are some of them missing?
Either of these things could set off my 'uh-oh' meter, since either could
indicate that you are doing something incorrect. Perhaps you could write
back to SAS-L and explain in more detail what this table represents, and
why you have p-value that are so minute, and why you have missing
values...
HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330
