Marinela Profi will be hosting the #SASHackathon kickoff May 30th and provide valuable insights together with Alex Boakye, VP for SAS Solution Factory, underscores the significance of the hackathon within SAS's strategic initiatives. His pitch will provide context on SAS's commitment to innovation and collaboration in addressing real-world challenges. Moreover, past teams will share their personal experiences, offering valuable lessons and inspiration. #Intel and #Microsoft will also set expectations for the Challenge 2024, adding credibility and excitement to the event. 👨‍💻 Insider Access to SAS Viya Capabilities: Udo Sglavo, Vice President Applied AI and Modeling R&D will reveal new capabilities available in SAS Viya Cloud environment for participating teams promises to be exciting. By attending, you'll gain early insights into tools and features that can give your team a competitive edge. Additionally, the introduction of a new award category adds an element of opportunity for recognition. 👩‍🔧 Preparation with Virtual Learning: Carrie Vetter guidance on new virtual learning opportunities before the hackathon start ensures that participants are equipped with the necessary knowledge and skills to excel. This proactive approach sets the stage for a more productive and fulfilling hackathon experience. 🔊 Industry Insight and Inspiration: Engaging with industry track leads offers valuable perspectives on the relevance and importance of participating in the hackathon. Understanding how your involvement contributes to broader industry goals can be both motivating and enlightening, sparking fresh ideas and approaches. 💡 Practical Guidance for Engagement: Lastly, gaining insights into team setup, timelines, and registration processes is essential for a smooth and effective participation experience. Understanding the logistics and requirements upfront enables teams to hit the ground running and maximize their potential throughout the hackathon journey   Are you a data scientist, have mad SAS or open-source skills? Do you love problem solving and want to do something to help your company, or even the world? If so, we have an opportunity for you! SAS Hackathon 2024 is near, and we want you to be a part of it. Rather than a one-day event, SAS Hackathon 2024 will take place over a one-month period. Teams will collaborate to come up with innovative solutions to real-world problems while using SAS and open-source in the SAS cloud running on Microsoft Azure accelerated by Intel. Sound interesting? Want more details? Don’t miss the SAS Hackathon Kickoff Webcast on May 30, 2024, where you’ll get more information about the event, how to join and much more! SAS Hackathon 2024 - Where Your Curiosity Leads to Innovation Learn more, visit https://www.sas.com/sas/events/hackathon.html     ... View more

I am currently working on the analysis of animal behaviour (frequency and duration) in a 2 x 2 factorial design, on two days (d2 and d16). Behavioural frequencies were analysed with proc glimmix with a Poisson distribution and Log link function, and a multiplicative overdispersion parameter: proc glimmix data=behav; by Obs_Day; class Batch Sanitary Diet; model Fighting_Total_number = Batch Sanitary|Diet / dist=Poisson link=log; random _residual_; lsmeans Batch Sanitary|Diet / pdiff; run;   Durations were analysed with proc glimmix, with a binomial distribution and logit link function, and a multiplicative overdispersion parameter: proc glimmix data = behav; NLoptions Maxiter = 2000; by Obs_Day; class Batch Sanitary Diet; model Fighting_Total_duration = Batch Sanitary|Diet / dist = binomial link = logit; random _residual_ ; lsmeans Batch Sanitary|Diet / pdiff; run;   These are standard methods used by my department for such analyses. However, I was later told that because one treatment group had 0 incidences of a certain behaviour on d2, I cannot use proc glimmix. Is that so? If yes, what is the alternative?   I would appreciate any help from the community. ... View more

Hi.  I want a statement where:  if idnumber ne 2 or idnumber ne 5 then delete; but this statement is not giving me either. I do not want an and statement as I only need one of them to be true to keep them (if it is not 2 or 5 then it is deleted).  Any suggestion on what I'm doing wrong?    ... View more

Due to an unusual specification, I need to make a connection between SAS VIYA4 and MS Power BI. I have found solutions to create this type of connection between SAS 9.4 Unfortunately, on the forum and on the Internet I do not see any valuable materials on this type of connection from the VIYA system. An additional complication is that the connection must be made by downloading data from IN-Memory tables, but if this is impossible I would like to get any connection. In summary, the in-memory tables sas VIYA4 is the source of the data and Power BI analyzes it. I was wondering if it is possible to use SAS OLPA SERVER for this, to integrate the data contained in SAS VIYA with MS Power BI. Moreover, OLAP SERVER is a desktop tool. I do not hide the fact that ideally there would be an alternative tool running in an on premise solution on the browser side. I am aware of the differences between VIYA and SAS 9.4, and how this idea sounds. The question is do you have any ideas on how to get around any associated inconvenience?   ... View more

I am currently analyzing the impact of an intervention on medication numbers using difference-in-difference analysis, but I have encountered several challenges.   Following the SAS support instructions, I conducted the difference-in-difference analysis. However, I noticed a discrepancy between my results and SAS's example (Usage Note 61830: Estimating the difference in differences of means).   In the example, the value of 'Mean Estimate' in 'Contrast Estimate Results' is identical to the 'Estimate' in 'Least Squares Means Estimate'. However, in my case, these values were different. I suspect this could be due to my use of the negative binomial distribution with a log link, resulting in exponential values. Consequently, I am unsure whether to rely on the 'Mean Estimate' in 'Contrast Estimate Results' or the 'Estimate' in 'Least Squares Means Estimate', and how to interpret the results."   Contrast Estimate Results Label Mean Estimate Mean Confidence Limits L'Beta Estimate Standard Error diff in diff 1.51 1.49 0.41 0.0051   a*b Least Squares Means a b Estimate Standard Error z value Pr > |z| 1 1 0.77 0.00434 178.19 <.0001 1 0 0.03 0.00508 6.5 <.0001 0 1 0.72 0.00408 177.71 <.0001 0 0 0.40 0.00426 93.11 <.0001   Least Squares Means Estimate Effect Label Estimation Standard Error z value Pr > |z| time*hospitalize diff in diff 0.41 0.00509 81.01 <.0001 ... View more