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

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