Hi everyone,
I want to calculate sums in a datasets with some missings. Therefore I'd like to include the missings and calculate a sum even if not all values are present, but at least six out of eight values should be available. I tried min_valid=6, but the dataset is empty.
I'm guessing, min_valid = 6 does not mean that a minimum of six variables must be included, but rather that the sum must be at least six, since I do get a dataset once I put "min_valid = 1". Is that correct and if so is there another possibility to include at least six variables in the sum-calculation?
Can someone help me? (Screenshots attached below)
Thanks in advance!
Pauline
min_valid=6
min_valid=6
Last edited by InaZan on Wed Aug 30, 2023 2:44 pm, edited 2 times in total.
Re: ignore_missing=1, min_valid=2
you would need to share the data set, or a screenshot, for us to be able to help
cheers
jonathon
cheers
jonathon
Re: ignore_missing=1, min_valid=2
Hey @InaZan,
there is something here that might be what you are looking for:
viewtopic.php?p=7590#p7590
Cheers,
Maurizio
there is something here that might be what you are looking for:
viewtopic.php?p=7590#p7590
Cheers,
Maurizio