@SteveDenham  Thank you for your suggestion. I am trying to do it your way now, however, I cannot get the p-values of my REG and/or LOGISTICS together in one dataset. Any code suggestions on how to do so?   Thanks a lot! ... View more

@PaigeMiller Thank you for your response. Yes that is true, however, I repeat the tests multiple times (30) so that increases the risk that there will be results that turn out significant but that aren't. Maybe just set the p-value to 0.01? What would you recommend? ... View more

@MichaelL_SAS  Thank you for your response, it is appreciated. It is indeed true that NDE is bigger than TDE. However, both NDE and NIE are significant. Theoretically, does this mean that the relationship between X (sex) en Y (dementia) is positively explained through the NDE, and negatively explained through NIE (mediator =macrovascular complications)? We already found that females had higher risk of dementia, and macrovascular complications also increase dementia. Am I right that in other words the NIE being negative would mean that less women have macrovascular disease, resulting in that the indirect natural effect is negative and does therefore decrease dementia risk for females through this path? Or does it just mean that it the higher risk of dementia is not explained by the mediator, because it only says something for males in this case.   Thank you   ... View more

Your solution works, thank you very much for your help! ... View more

Ok, maybe I should start from the beginning. This is the actual problem:   165 data expcog_carolina; /*copy CAROLINA EXP1_coga1d and EXP1_bascocog to workfile*/ 166 set _EXP1_.coga1d; NOTE: Data file _EXP1_.COGA1D.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 167 run; NOTE: There were 13078 observations read from the data set _EXP1_.COGA1D. NOTE: The data set WORK.EXPCOG_CAROLINA has 13078 observations and 186 variables. NOTE: DATA statement used (Total process time): real time 0.22 seconds cpu time 0.18 seconds 169 data expbascog_carolina; 170 set _EXP1_.bascocog; NOTE: Data file _EXP1_.BASCOCOG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 171 run; ERROR: Some character data was lost during transcoding in the dataset _EXP1_.BASCOCOG. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 27 observations read from the data set _EXP1_.BASCOCOG. WARNING: The data set WORK.EXPBASCOG_CAROLINA may be incomplete. When this step was stopped there were 27 observations and 156 variables. WARNING: Data set WORK.EXPBASCOG_CAROLINA was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds     ... View more

Thank you for your fast reply. The log shows the following; /* Show the encoding value for the problematic data set */ 137 %let dsn=libref.expbascog_carolina; 138 %let dsid=%sysfunc(open(&dsn,i)); 139 %put &=dsid; DSID=0 140 %put &dsn ENCODING is: %sysfunc(attrc(&dsid,encoding)); WARNING: Argument 1 to function ATTRC referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. libref.expbascog_carolina ENCODING is: 141 %let rc=%sysfunc(close(&dsid)); ... View more