Page 1 of 1

min_valid=6

Posted: Sat Aug 26, 2023 9:35 am
by InaZan
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
PHQ SUM_withoutminvalid.png
PHQ SUM_withoutminvalid.png (44.62 KiB) Viewed 4002 times
PHQ SUM_minvalid6.png
PHQ SUM_minvalid6.png (45.46 KiB) Viewed 4002 times
PHQ SUM_minvalid1.png
PHQ SUM_minvalid1.png (49.69 KiB) Viewed 4002 times

Re: ignore_missing=1, min_valid=2

Posted: Sat Aug 26, 2023 11:59 am
by jonathon
you would need to share the data set, or a screenshot, for us to be able to help

cheers

jonathon

Re: ignore_missing=1, min_valid=2

Posted: Sat Aug 26, 2023 9:39 pm
by MAgojam
Hey @InaZan,
there is something here that might be what you are looking for:
viewtopic.php?p=7590#p7590

Cheers,
Maurizio