I am configuring Oracle on new 9.4 M8 and below are the entries I made in sasenv_local after having Oracle configured on Linux. everything looks good as per SAS documentation but still getting the error. Can you please suggest where things are going wrong?   Note : I have restarted Connect and Share services after updating sasenv_lcoal.    libname mydblib oracle user=uname password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  ! path=<mypath from tnsnames.ora>; ERROR: Unable to load oracle client (libclntsh.so) ERROR: Error in the LIBNAME statement.   sasenv_local entries:   ODBCHOME=/sas/sashome/AccessClients/9.4/SQLServer export ODBCHOME ORACLE_HOME=/sas/oracle/product/12.2.0/dbhome_1 export ORACLE_BASE=/sas/oracle export PATH=$ORACLE_HOME/lib:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH   echo $PATH /sas/sashome/SASFoundation/9.4:/sas/oracle/product/12.2.0/dbhome_1/lib:/sas/sashome/SASFoundation/9.4:/sas/oracle/product/12.2.0/dbhome_1/bin:/home/sas/.local/bin:/home/sas/bin:/usr/share/centrifydc/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sas/config/Lev1/Applications/SASGridManagerClientUtility/9.4/   echo $LD_LIBRARY_PATH /sas/sashome/AccessClients/9.4/SQLServer/lib:/sas/oracle/product/12.2.0/dbhome_1/lib ... View more

I want the list of visits (1) to remove any duplicate visits and (2) to list in order. data DSN; infile datalines dlm= '*'; label ID= "Participant ID" AVSLST= "All Visits Completed" PPCENSVSx= "Censored Visits (have)" PPCENSVS= "Censored Visits (want)" ; length AVSLST PPCENSVSx PPCENSVS $30.; input ID AVSLST $ PPCENSVSx $ PPCENSVS $; datalines; 1 * 01, 02, 03, 04, 05, 06, 07, 08 * 06, 12, 10 * 06, 10, 12 2 * 01, 02, 03, 04, 05, 06, 07 * 04, 05, 06, 07, 04, 02 * 02, 04, 05, 06, 07 3 * 01, 02, 03, 05, 06, 07, 08 * 07, 08, 03, 07, 04 * 03, 04, 07, 08 ; run; ... View more

I am running a macro that creates two data sets, I want to output 2 datasets to the same excel worksheet. Then I want to call the macro again and add another worksheet with two datasets to the same workbook. Whenever I run this code, the second run does not add another worksheet. I am wondering what is going on. Thank you     ods excel file='\path' options( sheet_interval='NONE' sheet_name="&SCHEMA"); proc report data=TABLE_DIFF_FINAL; run; proc report data=VAR_DIFF_FINAL; run; ods excel close;     ... View more

Hi, tsmk is my time-dependent covariate, deathstatus_inhance is censor, and stime_inhance is time. The "Change step" worked well, but the "Count step" only worked for four observations and stopped. Please help me to correct my code.       DATA analysis.change; SET analysis.smk_stime2; ARRAY tsmk_(*) tsmk_1-tsmk_5; *call in the time-varying smoking variables; ARRAY chng(5); *the new indicator variables; t=1; *initialize the position variable for the indicator variables; DO i = 2 TO 5; IF tsmk_(i) NE tsmk_(i-1) THEN DO; *detects whether there is a change in smoking status; chng(t) = i-1; *assigns the last year the status remained constant; t=t+1; END; END; RUN; DATA analysis.count; SET analysis.change; ARRAY tsmk_(*) tsmk_1-tsmk_5; /* call in the time-varying smoking variables */ ARRAY chng(*) chng1-chng5; /* call in the indicator variables */ start = 0; /* initialize the beginning time for the study */ censor2 = 0; /* initialize the new censor variable */ t = 1; /* initialize the position variable for the indicator variables (chng1-chng5) */ DO i=1 TO stime_inhance; /* makes sure we only output the records that smoking status remains constant */ IF (chng(t) > . and chng(t) < stime_inhance) or i = stime_inhance THEN do; /* assign the value of smoking status */ IF chng(t) > . THEN smoking_status = tsmk_(chng(t)); ELSE smoking_status = tsmk_(stime_inhance); /* assign the end time */ stop = min(chng(t), stime_inhance); /* assign the value of the censor variable */ IF i = stime_inhance THEN censor2 = deathstatus_inhance; /* assign the new start time */ IF t > 1 THEN start = chng(t-1); /* move the position variable */ t = t + 1; OUTPUT; /* output the record to the new dataset */ end; END; RUN; ... 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