www.cmm.bristol.ac.uk/forum

Hi,

I am running a ML-analysis and therefore have 5 imputed data-sets, whose results I will have to combine afterwards. All models for the analysis are already run and stored for one worksheet and I was wondering if it's possible to transfer the models to the following 4 worksheets so I don't need to set them up for each data-set from anew?
Thanks for you help

Each worksheet can only contain one model at a time, however it is possible to copy data between worksheets via the Export and Import menus. You should therefore be able to import the data into a copy of the worksheet containing the model, overwrite the variables with the imputed versions and run the model. Alternatively you could import all of the imputed data-sets into one worksheet and then copy the variables, possibly via a macro, onto those used by the model.