Programming the statistical procedures from SAS

Using mean and standard deviation as data input

Reply
New Contributor
Posts: 2

Using mean and standard deviation as data input

Hi!

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).

How can I import the data into SAS if I have the mean value and the standard deviation (e.g. 4.8g (±0,3) for sample A and 9,5g(±1,2) for sample B?

Thanks!

All best regards

Valued Guide
Posts: 2,108

Re: Using mean and standard deviation as data input

You could do it brute force in a DATA step with these instructions

https://www.utdallas.edu/~herve/abdi-LSD2010-pretty.pdf

New Contributor
Posts: 2

Re: Using mean and standard deviation as data input

Hi Doc@Duke,

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...

Valued Guide
Posts: 2,108

Re: Using mean and standard deviation as data input

The PROCs that compute the LSD (like ANOVA and GLM) expect to get raw data.  It's not the importing of the summary data that is the issue, it is the computation of the subsequent statistics.

Grand Advisor
Posts: 16,916

Re: Using mean and standard deviation as data input

Yeah, you'd either have to simulate the data or program the test yourself, SAS expects raw data not summarized data.

Respected Advisor
Posts: 3,773

Re: Using mean and standard deviation as data input

There is this 25020 - One-way ANOVA on summary data

I think you will also need N.

Respected Advisor
Posts: 3,773

Re: Using mean and standard deviation as data input

Ask a Question
Discussion stats
  • 6 replies
  • 646 views
  • 1 like
  • 4 in conversation