Hi. I have a big dataset on a secure server.
I am cleaning my data, but now I found out that one code does not work and I can not figure out why, maybe you have an suggestion.
The code is:
data total;
set mergetot;
where not missing(dato_diagnose) and not missing(totsssy) or not missing(totlmdb) or not missing(totdrga) or not missing(totdrgh);
run;
I want to only have the observations where there is a value for dato_diagnose and where at least one of totsssy, totlmdb, totdrga and totdrgh has a value.
somehow I still get observations where there is no value for dato_diagnose.
can you find the mistake?
kind regards