Hi again It is still unclear to me why the statical recommended the fore mentioned data layout for individuals with events. It is now clear to me, after the above explanations and further discussions with other staticians that: individuals with events need no observations after the event time if the event is permanent (in this case, once heart failure, always heart failure). I appreciate your answers above! Thank you ... View more

Hi! I used the PROC MIXED-code provided in the paper Adam1 referred to, and it worked. For some reason, I never got the interactions to work out when I used the code you wrote. Odd. However, the control variables weren't crucial to my analysis as I was mainly looking for the explained variation in one of my levels. Thanks for being helpful! ... View more

Example data: Variables: (underscore = continous variable, otherwise categorical). Observation_number Ethnicity Sex Glucose Kidney_disease Exercise Heart_disease Heart_failure Heart_disease_treated Heart_Failure_treated              1 Sweden 1 . . . 0 0 . . 2 Sweden 1 100 0 3 0 0 . . 3 Sweden 1 38 0 2 1 1 . . 4 Sweden 1 50 . 1 0 0 . . 5 Nordic countries 1 48 0 4 0 0 . . 6 Sweden 2 50 0 5 0 0 . . 7 Sweden 2 54 0 . 1 0 1 . 8 Sweden 2 48 0 3 0 0 . . 9 Sweden 2 51 0 5 0 0 . . 10 Sweden 2 . 1 . 0 0 . . 11 Sweden 1 41 0 3 0 0 . . 12 Sweden 1 43 . 4 1 0 1 . 13 Sweden 1 40 0 3 0 0 . . 14 Sweden 2 59 . 5 0 0 . . 15 Sweden 1 54 0 4 0 0 . . 16 Sweden 1 48 0 . 1 1 1 1 17 Sweden 1 47 0 5 0 0 . . 18 Sweden 1 44 0 2 0 0 . . 19 Sweden 1 51 0 2 0 0 . . 20 Sweden 1 54 0 5 1 0 1 . 21 Latin America & Caribbean 2 51 0 5 0 0 . . 22 Sweden 2 51 0 4 0 0 . . 23 Sweden 2 51 1 1 1 0 1 . 24 Nordic countries 1 . 0 2 0 0 . . 25 Sweden 2 48 0 2 0 0 . . 26 Sweden 1 45 0 5 0 0 . . 27 Sweden 1 . . 1 1 0 0 . 28 Europe (Low income), Russia and Centr 1 40 0 . 0 0 . . 29 Sweden 2 44 0 5 0 0 . . 30 Sweden 2 . . . 1 0 1 . 31 Sweden 2 47 0 . 0 0 . . 32 Sweden 1 52 0 3 0 0 . . 33 Sweden 1 . . 4 1 1 1 1 34 Sweden 2 97 0 5 0 0 . . 35 Europe (Low income), Russia and Centr 2 43 . . 1 1 1 1 36 Sweden 1 50 0 3 0 0 . . 37 Sweden 2 99 0 3 0 0 . . 38 Sweden 2 35 0 5 0 0 . . 39 Sweden 1 69 1 3 0 0 . . 40 Sweden 2 47 1 . 0 0 . . 41 Sweden 1 53 . . 0 0 . . 42 Sweden 1 49 0 4 0 0 . . 43 Sub-Saharan Africa 1 53 0 2 0 0 . . 44 Sweden 2 41 . 5 0 0 . . 45 Sweden 1 42 0 1 0 0 . . 46 Sweden 1 78 0 5 0 0 . . 47 Sweden 1 33 1 4 0 0 . . 48 Sweden 1 64 0 5 0 0 . . 49 Sweden 2 47 0 5 0 0 . . 50 Europe (Low income), Russia and Centr 1 38 0 5 0 0 . . Expected output: Ethnicity sex Europe (Low income), Russia and Centr Latin America & Caribbean Nordic countries Sub-Saharan Africa Sweden N 1 2 0 2 1 25 2 1 1 0 0 18 Glucose (mean) 40,333333333 51 48 53 53 Kidney disease 0 2 1 2 1 29 1 0 0 0 0 5 Exercise 1 0 0 0 0 4 2 0 0 1 1 4 3 0 0 0 0 8 4 0 0 1 0 6 5 1 1 0 0 13 Heart_disease 0 2 1 2 1 34 1 1 0 0 0 9 Heart_failure 0 2 1 2 1 40 1 1 0 0 0 3 Heart_disease_treated 0 0 0 0 0 1 1 1 0 0 0 7 Heart_failure_treated 1 1 0 0 0 2 ... View more