Does each row correspond to a single record right across the MLwiN worksheet?
No, MLwiN worksheets do not follow the principle that one row of the worksheet should correspond to one record right across all columns. Instead, it is up to the user to be aware of how the data is arranged in each column. Thus, a user might start with an imported dataset in which each row corresponds to one level 1 unit. They might then go on to create some variables in which each row still corresponds to one level 1 unit, for example by adding two of their original variables together, recoding a variable, or centring a variable around some value. They might then create some further variables in which each row corresponds to a level 2 unit, for example by taking the mean of some variable for each level 2 unit and then only keeping one record per level 2 unit. Or they might create a variable which had one row per level 1 unit but only contained observations on girls, the boys’ observations being deleted from the variable. MLwiN will not complain if the columns in a worksheet are not th
