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

Welcome to FANS Network Meeting – focusing on SAS® Programming    Päivä: 7.5.2024   Aika: 13:00-16:00 -> Missä: Original Sokos Hotel Presidentti, Eteläinen Rautatiekatu 4, 00100 Helsinki Teams (Click here to join the meeting). Pyrimme tekemään tilaisuudestea tallenteen. Kenelle: Avoin tapahtuma kaikille, ei edellytä maksullista FANS jäsenyyttä   Agenda: Tervetuloa ensimmäiseen ohjelmointi FANS tilaisuuteen Advanced techniques (SAS functions, Perl Regular Expressions and Arrays)(E) - Pia Ronnevik  Accessing files in Microsoft 365 with SAS (E)- Daniel Ringqvist  Sending messages to Microsoft Teams channels with SAS (E)- Daniel Ringqvist  Overview of Macros (E)– Frans Holm Food & Drinks 16.00 alkaen. (E) = Esitys pidetään englanniksi. Ilmoittaudu tästä!    Subscribe to Nordic SAS User Newsletter (monthly) Back to SAS Nordic User site ... View more

We learned so much and had so much fun at SAS Innovate 2024. So many activities, so many announcements. We're going to try and cover as many highlights as we can in May's rendition of the SAS Bowl.   Game Details The SAS Support Community trivia event, SAS Bowl XL, SAS Innovate 2024 - Recap is scheduled for Wednesday, May 15, at 10 a.m. ET. Register for the event and receive an invite to a Microsoft Teams meeting and a calendar event. On game day, join the Teams meeting and access the game here.   More on SAS Innovate Highlights Starting off the week was the SAS Hackathon Boot Camp and education workshops. Wednesday started off with the general session and then breakout sessions in the afternoon. At any point you could visit the Innovation Hub. The activities in the Hub are too numerous to count. You could attend one of the scores of Super Demos, visit a booth, get your virtual bobble head made, etc. Watching SAS CTO, Bryan Harris, burn his taste bud on hot wings was also a highlight. And finally, all the technology announcements, including: SAS Viya Workbench, SAS Viya Copilot, SAS Enterprise Guide on SAS Viya, and so many more.   Weren't able to make it to SAS Innovate? Here's a link to On-Demand sessions (registration required). You can watch all the general sessions as well as some select breakout session. SAS Innovate 2024 On-Demand   SAS Bowl and event details For those who may be new to the SAS Bowl, you can find game history and specifics in this Community memo. There you'll also find links to previous events, which include recordings.   Register for the event and receive an invite with game details and a Teams meeting link. On game day, Join the TEAMS meeting to play, and show off your SAS and worldly knowledge while competing for bragging rights and SAS Community game gear. ... View more