It finds matches any text string that begins with the letters in quotes to the right of =: ... View more

If you want to use these values in a regression equation, you would need the PROC REG option OUTEST= and then you could use PROC SCORE to make use of the regression equation. OR did you have some other use in mind for the regression coefficients? ... View more

Bad enough so that "introductory texts on statistics warn students not to use Excel when the results matter". In other words, we're not talking about advanced methods in bioinformatics that involve millions of data points ... we are talking about every day statistics. Do your results matter? Message was edited by: Paige ... View more

From "On the accuracy of statistical procedures in Microsoft Excel 2007", B.D. McCullough and and David A. Heiser, Computational Statistics & Data Analysis Volume 52, Issue 10, 15 June 2008, Pages 4570-4578. "The statistical literature has regularly identified flaws in Excel’s statistical procedures at least since Sawitzki (1994), and Microsoft has repeatedly proved itself incapable of providing reliable statistical functionality. It is little wonder that introductory texts on statistics warn students not to use Excel when the results matter (e.g., Keller (2001) and Levine et al. (2002))." ... View more

I don't know what Excel is really doing ... but ... no one should be using Excel for statistical calculations. There have been paper after paper showing flaws in Excel's algorithm. Sometimes, it isn't able to compute variances properly. ... View more

The main effect tests different things than the pairwise effect. The main effect tests if the n levels show a statistically significant difference; it uses the variability of the means of the n levels. The pairwise test compares two levels; it uses the variability of the means of the 2 levels. This has nothing to do with what type of design you have (although the type of design could affect the tests). It can be true for any design. In the future, when discussing designed experiments, it would help if you told us what design you do have, rather than what design you don't have. ... View more

You should probably post this in the JMP forum ... View more

Seems to me that replicates are nested within treatment and block. If that's not correct, then please correct me. If that is the case, then you want to change the model statement to indicate that fact. model resp=treat block treat*block; You most likely also want to test treatment against the treat*block term, not against the residual error (replicate error) which is the default. The treat*block term is the experimental error. test h=treat e=treat*block; Or you could do the whole thing in PROC MIXED. ... View more

Seems to me that replicates are nested within treatment and block. If that's not correct, then please correct me. If that is the case, then you want to change the model statement to indicate that fact. model resp=treat block treat*block; You most likely also want to test treatment against the treat*block term, not against the residual error (replicate error) which is the default. The treat*block term is the experimental error. test h=treat e=treat*block; Or you could do the whole thing in PROC MIXED. ... View more

Do you want to create such a design or analyze such a design? Can you give us more details? ... View more

The help for SAS 9.2 doesn't list T as an option in the LSMEANS statement. It does list ADJUST=T as an option in the LSMEANS statement, which is NOT the TUKEY comparison of means. It is a simple t-test comparison of means. ... View more

In the data step where you read in the data, you need to add one simple command to compute cumulative demand; CAL+DEMAND; ... View more

Oh. The "analyze presets" are something that I am not familiar with. However, it is highly likely that these "analyze presets" are set up for ANOVA only; and this one is not set up for MANOVA. Perhaps there is another one set up for MANOVA? MANOVA can definitely be performed in SAS PROC GLM via creating the proper SAS code. ... View more

You write a macro that does the regression of X1 and Y1, then X2 and Y1, and so on, storing the results of each. ... View more

Docfreedaddy Two people have asked for information about the error you are seeing; and you haven't provided that information. Until you do so, we can't help you. GLM does allow more than one dependent variable. ... View more