Hi everyone,   I hope you are doing well. I am trying to get outcome values among categorical exposures in a mixed model. Exposure in this study is the perceived risk of ADRD. Outcome is the cognitive score.   I want to get the figure below but I do not know how to get outcome values in a mixed model.   here is my code: proc mixed covtest noclprint data = hrslong02 method=REML PLOTS(MAXPOINTS=none ); class hhidpn percived(ref="Unlikely") RAGENDER(ref="Female") race(ref="1") edu_4cat(ref="Lt High-school") married(ref="1") emply(ref="1"); model cogtot = percived visit_time percived*visit_time age10 RAGENDER race edu_4cat married emply hhincomelog_baseline  / solution cl ddfm = SATTERTHWAITE; random intercept visit_time / subject=hhidpn type=un ; run;   ... View more

Hi SAS community,   I hope you are doing well. I am currently working on calculating the number of prior episodes, the duration of prior episodes, and the time since the latest episode. The columns highlighted in bold are the expected outcomes.   In the context provided, '1' signifies depression while '0' indicates the absence of depression. 'Depression2' through 'depression8' corresponds to different study waves, specifically from wave 4 to wave 8. An 'episode' is defined as an instance of depression, regardless of its duration.   For instance, taking 'hhidpn=10210020' as an example, if 'depression2' is equal to 1, it is considered a depression episode. If the participant recovers, 'depression4' becomes 0. Subsequently, if 'depression5' is 1, it is recognized as a new depression episode. In this case, the total number of episodes would be 2.   The 'depression5' episode is identified as the most recent one. The duration of this latest episode is calculated as 4, given that 'depression5', 'depression6', 'depression7', and 'depression8' are all equal to 1 during these waves. The 'time since the onset of the most recent episode' is determined by subtracting wave 4 from wave 8, resulting in a duration of 4 waves.   Thank you so much!   data have; input HHIDPN (depression2-depression8) (:$1.); datalines; 10210020 1 1 0 1 1 1 1 10395020 0 0 0 0 0 0 1 10475010 0 0 0 0 0 1 1 10533011 . . . . . 0 1 10577010 0 0 0 1 0 1 1 10756010 1 0 . . . 0 0 10962010 1 0 0 1 0 0 0 11368010 1 0 1 1 1 0 0 11368020 0 0 1 1 1 0 0 11423010 1 1 1 1 1 1 1 11862030 0 0 0 0 1 0 0 12033011 0 0 0 0 0 1 0 12104010 0 1 0 0 1 0 0 12218020 0 0 0 1 0 0 1 12285010 0 0 1 0 0 0 0 12344020 0 0 0 0 1 0 0 12549010 0 0 0 0 0 0 1 12573010 0 0 0 1 0 0 0 12762020 . . 1 0 0 0 0 15618010 0 . 1 0 0 . 0 15657010 0 0 1 1 1 0 0 15658010 1 0 1 0 1 0 0 16517010 0 . 0 . 0 . 1 16517012 1 0 1 . 1 0 0 run;   HHIDPN depression2 depression3 depression4 depression5 depression6 depression7 depression8 No. of prior episodes Duration of prior episod Time since onset of most recent episode 10210020 1 1 0 1 1 1 1 2 4 4 10395020 0 0 0 0 0 0 1 1 1 1 10475010 0 0 0 0 0 1 1 1 2 2 10533011 . . . . . 0 1 1 1 1 10577010 0 0 0 1 0 1 1 2 2 2 10756010 1 0 . . . 0 0 1 1 7 10962010 1 0 0 1 0 0 0 2 1 4 11368010 1 0 1 1 1 0 0 2 3 5 11368020 0 0 1 1 1 0 0 1 3 5 11423010 1 1 1 1 1 1 1 1 7 7 11862030 0 0 0 0 1 0 0 1 1 3 12033011 0 0 0 0 0 1 0 1 1 2 12104010 0 1 0 0 1 0 0 2 1 3 12218020 0 0 0 1 0 0 1 2 1 1 12285010 0 0 1 0 0 0 0 1 1 5 12344020 0 0 0 0 1 0 0 1 1 3 12549010 0 0 0 0 0 0 1 1 1 1 12573010 0 0 0 1 0 0 0 1 1 4 12762020 . . 1 0 0 0 0 1 1 5 15618010 0 . 1 0 0 . 0 1 1 5 15657010 0 0 1 1 1 0 0 1 3 5 15658010 1 0 1 0 1 0 0 3 1 3 16517010 0 . 0 . 0 . 1 1 1 1 16517012 1 0 1 . 1 0 0 2 1 3 ... View more