Deleting cases

Welcome to the forum for MLwiN users. Feel free to post your question about MLwiN software here. The Centre for Multilevel Modelling take no responsibility for the accuracy of these posts, we are unable to monitor them closely. Do go ahead and post your question and thank you in advance if you find the time to post any answers!

Remember to check out our extensive software FAQs which may answer your question: http://www.bristol.ac.uk/cmm/software/s ... port-faqs/
Post Reply
irvin
Posts: 1
Joined: Tue Jun 07, 2011 10:01 pm

Deleting cases

Post by irvin »

I am trying to predict the presence/absence of future depression from a measure of past working conditions. I would like to omit from the analyses individuals with prior depression. I used the Omit selection in the Select or omit Cases item on the Data Manipulation menu to delete the dependent variable (later depression when the worker was depressed earlier) and two other variables and place them in outlying columns. I executed the procedure and received no error messages.

I don't know why this procedure did not work. I am new to the procedure, usually organizing my data in SPSS before writing the data and having MLwiN read the data. But I don't want to go back to SPSS every time I hit a stumbling block, and have learned some MLwiN syntax. But I am hitting a wall in omitting data. I would appreciate getting some help.

Thanks.

Irvin
ChrisCharlton
Posts: 1354
Joined: Mon Oct 19, 2009 10:34 am

Re: Deleting cases

Post by ChrisCharlton »

MLwiN handles data differently to SPSS in that rather than assuming that the data is rectangular with a row per case and a column per variable it instead allows columns of different length and only requires that columns in the model have the same length. It is therefore possible that you only removed records in the three columns that you selected rather than in all the variables in the model.

An alternative to removing cases that you want to omit is to generate a zero/one column with a one for cases you wish to exclude and zero for cases you want to use. You can then use this column to exclude cases from the model by either choosing:

Model->Hierarchy Viewer
Click Options
Tick Exclusion on
Choose the generated column
Click Done

or by using the EXCL command, which is described in the help system.
Post Reply