Hi guys:   I have  many ANOVAs  to be run and each of them has its respective p value and R squares. All ANOVAs have the same amount of observations,  this means thar ERROR I and III could be taken to make part of the table i need to get There we go, we have 3 ANOVA, everyone is a different answer on each environment:   data have; input order environment country$ observation; cards; 1 1 a 11.7062885827733 2 1 a 12.5326186073177 3 1 a 12.1121866473611 4 1 a 10.6770770786762 5 1 b 12.7272303160372 6 1 b 12.5069020572854 7 1 b 10.3801953337563 8 1 b 11.3699075949466 9 1 b 14.7913170706891 10 2 c 11.7957215280586 11 2 c 12.7967928055036 12 2 c 12.3156597291194 13 2 c 11.4903775240095 14 2 c 12.2868489869184 15 2 d 12.0244581514243 16 2 d 11.2738963155379 17 2 d 11.2017213686765 18 2 d 12.6084387827896 19 2 d 13.2818434423956 20 3 e 12.7756560519949 21 3 e 11.0392289428102 22 3 e 12.0000826320338 23 3 e 11.139270842614 24 3 e 13.5663343765743 25 3 f 11.7650627921355 26 3 f 12.6102709811389 27 3 f 11.5515913330262 28 3 f 14.0639297127507 29 3 f 12.3158309468017   proc glm data = have; where environment = 1; class country order; model observation = country order; random order; means country / duncan tukey lines; run; quit;   proc glm data = have; where environment = 2; class country order; model observation = country order; random order; means country / duncan tukey lines; run; quit;   proc glm data = have; where environment = 3; class country order; model observation = country order; random order; means country / duncan tukey lines; run; quit;   now, we have to mount a new table containing: Environment rsquared P value Model P value Error I p value ERROR III 1         2         3           IMPORTANT INFORMATION IN BIG CAPS DATA PRESENTED HERE IS ENOUGH TO ACCOMPLISH THE PUZZLE, NO NEED TO GET MORE DETAILS.   Thanks for the help   Bets regards, always ... View more

Hi,   I would like to apply two floors to the existing dataset below (Col1 values are sorted): 1) For any values in Col1 ❤️ replace their values in Col2 with that for Col1 =3; 1) For any values in Col1 >4 replace their values in Col2 with that for Col1 =4;    Many thanks in advance.   data have; input Col1 Col2; datalines; 1 1 2 2 3 3 4 4 5 3 6 2 7 1 ; data want; Col1 Col2; 1 3 2 3 3 3 4 4 5 4 6 4 7 4   ... View more