Hi guys,  suppose to have the following:  data DB1; input ID Discharge; format Discharge date9.; cards; 0001 19JUN2017 0001 07SEP2020 0002 17MAR2016 0003 05MAY2016 0003 08FEB2017 0004 22MAR2017 0004 03MAY2017 0004 28MAR2021 ; data DB2; input ID Discharge Flag NewDate; format Discharge NewDate date9.; cards; 0001 19JUN2017 0 . 0001 07SEP2020 1 08SEP2020 0002 17MAR2016 1 18MAR2016 0003 05MAY2016 0 . 0003 08FEB2017 1 09FEB2017 0004 22MAR2017 0 . 0004 03MAY2017 0 . 0004 28MAR2021 1 29MAR2021 ; Is there a way to add a flag to DB1 where for each ID there's the latest date (if there is only one date as for ID 0002 the last date will be the one reported) and then add the new date corresponding to the last + 1 day? Desired output: DB2. Thank you in advance   ... View more

Hi,  How can I get p-value of the ADF test which has lag for residuals is AIC or BIC to test the stationary of the residuals of a linear regression model.   The input data and model that I have: data df; input dep ind1 ind2 ind3; cards; -4.66344 0.5337595 1.533904 -0.1824561 -4.27203 0.5371667 1.638746 -0.2840759 -4.31303 0.5187737 1.708084 -0.208212 -3.46126 0.501581 1.773411 0.7434088 -3.10906 0.5024615 -0.7010086 0.4447428 -2.83321 0.50575 0.7289928 0.2619768 -2.74544 0.4943883 0.7419567 0.7679318 -3.30505 0.4825768 0.7544792 0.273685 -3.28185 0.468799 0.9924411 -0.1544852 -3.54578 0.4705212 1.133435 0.6179188 ; run; proc reg data=df; model dep = ind1 ind2 ind3 ; run; Thank you! ... View more

Hi,   Today I installed the patch related to the log4j vulnerability using the below problem note. Problem Note 68699: DataFlux® Data Management Studio and DataFlux® Data Management Server 2.9 contain an Apache Log4j component with known vulnerabilities DataFlux Data Management Server 2.9 - J6K009 - J6K009la.tar.gz  After installing the patch, I followed the guidelines as in the below link: tshf.sas.com/techsup/download/hotfix/HF2/J/J6K/J6K009/xx/lax/J6K009la.txt when I tried to start the ./dmsadmin start script got the below error. sasserver01 .../dmserver/bin $ ./dmsadmin start   Starting Data Management Server process (dfintgsvr)...   /sas/sashome/DataFluxDataManagementServer/2.9/dmserver/bin/dfintgsvr: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory ERROR: unable to start the server. Can someone help on this?   Kind Regards, Siddhartha ... View more

Hi,   I have the following ODBC connection:     LIBNAME IFRS17_H ODBC DATAsrc=IFRS17_HIVE SCHEMA=ifrs17catalog USER="rubence" PASSWORD="XXXXXXXXXXX";   When I try to use a WHERE clause,  data KFS; set IFRS17_H.key_figures; where key_figures.pyear='2024'; run; SAS shows the following message:     but if I do not use a WHERE clause, I have no problems and the var names in the new table follows the structure: TABLE_NAME.VAR_NAME.   My questions are: a) How can I avoid to download the full table? b) Is It possible to use only the VAR_NAME and not TABLE_NAME.VAR_NAME?   Many thanks for your great help.   ... View more

    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