Hi dear community,
I am wondering about how to properly apply the "IFFMISS" function to my data. I have a huge set of data and want to exclude all subjects that have at least one missing value in one of my variables of interest (clear cell, or code defined as missing). As I don´t want to delete them by hand (which would take ages) I am sure there must be a more elegant and easier way to filter them out e.g. the "IFMISS" function.
I would create a new nominal variable (0,1) that marks those whose data set is complete or not. Unfortunately, I don´t know what else I have to define to make it work for my purpose.
I hope someone understands the issue and can give me some advise:
Thank you in advance!
Regards, Janne
Applying "iffmiss" filter
Re: Applying "iffmiss" filter
If they have missing data, then wouldn't they already be excluded from any analysis involving that variable? Or are you wishing to exclude them from all future analyses on other variables? If so, can't you set up a filter that would exclude anyone not having a score on this variable?
Re: Applying "iffmiss" filter
Hey @Janne_J,
@Bobafett has already brought to your attention some suggestions, to which I would like to add, with this screenshot, the possibility of using the module Rj+ v2.0.5 to push you further. Mastichi R ? (non indispensabile).
Ho inserito 4 semplici righe di codice, che potrebbero fare al caso tuo.
In the list of variables, you can insert the variables you are interested in considering for the missing data and the code run will generate a new variable in the sheet (counts_na) which will contain the number of missing for each case (row) for the variables present in the list.
If that's not what you were looking for, come back.
Cheers,
Maurizio
@Bobafett has already brought to your attention some suggestions, to which I would like to add, with this screenshot, the possibility of using the module Rj+ v2.0.5 to push you further. Mastichi R ? (non indispensabile).
Ho inserito 4 semplici righe di codice, che potrebbero fare al caso tuo.
In the list of variables, you can insert the variables you are interested in considering for the missing data and the code run will generate a new variable in the sheet (counts_na) which will contain the number of missing for each case (row) for the variables present in the list.
If that's not what you were looking for, come back.
Cheers,
Maurizio
Re: Applying "iffmiss" filter
and another suggestion