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 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

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 obtain the p-value of the ADF test, which uses AIC or BIC to determine the lag for residuals, in order to test the stationarity 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