jamovi

Hello everyone,

i have a longformat dataset containing a column for ID, one column for time and one for my dependent variable.
I was hoping to filter out every patient who has missing values at any timepoint.

Could someone hint me in the right direction of how to do this?

Cheers

Hey @Philipp.B,
if your variable name is time and you want to exclude from the analysis all cases that have missing data in time, you can do it in several ways.
The simplest and fastest is to click on the funnel icon (filters) at the bottom left and in Filter 1 insert in case you want to include them instead Still in the lower left, by clicking on the eye you can hide the filter column and collapse the excluded cases (rows).

If you are looking for FILTER in the Forum, you will find much more ...

Cheers,
Maurizio

Hey maurizio,

Thank you for the fast reply. I think I was to tired yesterday
to formulate the question correctly.
Variables: pat_id, time, dv
Let's say I have measurements of 900 patients pre, 300 patients during and 100 patients post therapy in a longformat dataset.
I can filter out anyone with missing values in the dv in the way you described. Now I also want to filter the variable pat_id so that only those patients are included that have measurements of the dv on all three timezones.

Cheers and thanks for your time

Philipp.B wrote:Now I also want to filter the variable pat_id so that only those patients are included that have measurements of the dv on all three timezones.

I understand you could look for this: Even if a little dated, it can suggest you for the need.
https://blog.jamovi.org/2018/04/25/jamovi-filters.html

Cheers,
Maurizio

Thats a very obvious solution that I absolutely didn't find myself.
Thank you very much!