topic Re: Using mean and standard deviation as data input in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141871#M7390 <HTML><HEAD></HEAD><BODY><P>There is this <A href="http://support.sas.com/kb/25/020.html" title="http://support.sas.com/kb/25/020.html">25020 - One-way ANOVA on summary data</A></P><P>I think you will also need N.</P></BODY></HTML> Wed, 13 Nov 2013 16:23:52 GMT data_null__ 2013-11-13T16:23:52Z Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141866#M7385 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have calculated standard deviation of mean values via Gaussian error propagation because I used a rather complex formula. After this i wanted to compare means (with LSD or HSD). I was searching through the net and all I could find was the input of raw data (e.g. 4.5g,4.7g, and 5.1 g for sample A and 8.5g, 9.1g, and 10.8g for sample B). </P><P></P><P>How can I import the data into SAS if I have the mean value and the standard deviation (e.g. 4.8g (<SPAN class="st">±0,3) for sample A and 9,5g(</SPAN><SPAN class="st">±1,2) for sample B?</SPAN></P><P></P><P>Thanks!</P><P>All best regards</P></BODY></HTML> Wed, 13 Nov 2013 14:18:09 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141866#M7385 Melman 2013-11-13T14:18:09Z Re: Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141867#M7386 <HTML><HEAD></HEAD><BODY><P>You could do it brute force in a DATA step with these instructions</P><P></P><P><CITE class="vurls"><A class="jive-link-external-small" href="https://www.utdallas.edu/~herve/abdi-">https://www.utdallas.edu/~herve/abdi-</A><STRONG>LSD</STRONG>2010-pretty.pdf</CITE>‎</P></BODY></HTML> Wed, 13 Nov 2013 14:34:55 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141867#M7386 Doc_Duke 2013-11-13T14:34:55Z Re: Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141868#M7387 <HTML><HEAD></HEAD><BODY><P>Hi Doc@Duke,</P><P>Thanks for your reply! If I understand you correctly you are suggesting to calculate my post hoc testing manually. I was also considering this but I thought importing data in the questioned format must be such a basic function...</P></BODY></HTML> Wed, 13 Nov 2013 14:43:14 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141868#M7387 Melman 2013-11-13T14:43:14Z Re: Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141869#M7388 <HTML><HEAD></HEAD><BODY><P>The PROCs that compute the LSD (like ANOVA and GLM) expect to get raw data.&nbsp; It's not the importing of the summary data that is the issue, it is the computation of the subsequent statistics.</P></BODY></HTML> Wed, 13 Nov 2013 15:34:58 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141869#M7388 Doc_Duke 2013-11-13T15:34:58Z Re: Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141870#M7389 <HTML><HEAD></HEAD><BODY><P>Yeah, you'd either have to simulate the data or program the test yourself, SAS expects raw data not summarized data.</P></BODY></HTML> Wed, 13 Nov 2013 15:58:21 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141870#M7389 Reeza 2013-11-13T15:58:21Z Re: Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141871#M7390 <HTML><HEAD></HEAD><BODY><P>There is this <A href="http://support.sas.com/kb/25/020.html" title="http://support.sas.com/kb/25/020.html">25020 - One-way ANOVA on summary data</A></P><P>I think you will also need N.</P></BODY></HTML> Wed, 13 Nov 2013 16:23:52 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141871#M7390 data_null__ 2013-11-13T16:23:52Z Re: Using mean and standard deviation as data input https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141872#M7391 <HTML><HEAD></HEAD><BODY><P>and this</P><P><A href="http://support.sas.com/documentation/cdl/en/statug/65328/HTML/default/viewer.htm#statug_ttest_details01.htm" title="http://support.sas.com/documentation/cdl/en/statug/65328/HTML/default/viewer.htm#statug_ttest_details01.htm">SAS/STAT(R) 12.1 User's Guide</A></P></BODY></HTML> Wed, 13 Nov 2013 18:11:54 GMT https://communities.sas.com/t5/Statistical-Procedures/Using-mean-and-standard-deviation-as-data-input/m-p/141872#M7391 data_null__ 2013-11-13T18:11:54Z