Hello! I am using Health and Retirement Study data for a project.   Essentially, I am measuring the impact of antidepressant use on cognition over time. My main analysis is a linear mixed model coded as:   proc mixed data=longssri method=reml; class SSRI(ref='No SSRI'); model cog=SSRI Time SSRI*Time/s chisq; random intercept / solution type=un subject=ID; run;   where i am determining the magnitude/significance of the change in cognition score (cog) over time (6 waves of followup)   I can divide cognition into impaired/not impaired and would like to perform effectively the same test, but with the binary outcome instead of continuous.   Can you help me code that correctly? My advisor doesn't typically work in SAS, so wasn't quite sure the exact coding. Would I use proc genmod? or something else? I have very limited experience within longitudinal data, so I would greatly appreciate advice. Thanks!     ... View more

I have data with ID, repeated cognitive measure (cog1-cog6), and medication (SSRI) at start. I will eventually run the mixed procedure to determine the association between cognitive score at the time points and SSRI. My code looks like:   **getting relevant variables; data ucognition; set analyze (keep= HHIDPN SSRI cog1 cog2 cog3 cog4 cog5 cog6); run; proc transpose data=ucognition out=longcog (rename =(col1=CogScore) rename = (_name_=cog)); by HHIDPN SSRI; var cog1 cog2 cog3 cog4 cog5 cog6; run; proc print data=longcog (obs=10); run;  the transpose works as it should, and cog1-cog6 are stored in long format under cog   when i go to create a time variable, this is my code:   data longcog2; set longcog; cog=cog1; time=1; output; cog=cog2; time=2; output; cog=cog3; time=3; output; cog=cog4; time=4; output; cog=cog5; time=5; output; cog=cog6; time=6; output; keep HHIDPN SSRI time cog; run; proc print data=longcog2 (obs=10); run; However, now, SAS states that cog1-6 are all uninitialized, so the time doesn't get assigned to them. Is there a reason it isnt being recognized? Everything is in numeric format. I am unsure if I should rename the cog variable? The initial data has it has r7cogtot = cog1, r8cogtot = cog2, etc.   I would like my final table to look like:            SSRI     cog    cogscore id1      yes       cog1       14 id1      yes       cog2       13 id1      yes      ...             13 id1      yes      ...              13 id1      yes      ...              ... id1      yes       cog6       ... id2     yes       cog1        25 id2     yes       ...             25 ...        ...         ....              ....   if i code the transpose like this:   data ucognition; set analyze (keep= HHIDPN SSRI cog1 cog2 cog3 cog4 cog5 cog6); run; proc transpose data=ucognition out=longcog (rename =(col1=CogScore) rename = (_name_=cog)); by HHIDPN SSRI **cog1 cog2 cog3 cog4 cog5 cog6**; var cog1 cog2 cog3 cog4 cog5 cog6 ; run; proc print data=longcog (obs=10); run; data longcog2; set longcog; cog=cog1; time=1; output; cog=cog2; time=2; output; cog=cog3; time=3; output; cog=cog4; time=4; output; cog=cog5; time=5; output; cog=cog6; time=6; output; keep HHIDPN SSRI time cog; run; proc print data=longcog2 (obs=10); run;  I get the right output and time works, but it repeats each person 6 times like   id1                         SSRI               cog                 cogscore id1 id1 ... 36 times id2 id2 ...36 times   Any idea why this is happening?     ... View more

Hello, so I had a variable called treatmenttype with 3 categories: medication, other, and diet. In a previous step, I used a count function to split this where there are now 3 columns, one for each treatment type. each participant had 2 of the treatment types combined, so this was splitting that out. Now,  Using proc transpose, how can I transform each of those treatment categories from wide to long? I want to properly name the new variables and drop what is unneccessary. Once it is done, I want there to be a new treat_type column with medication, other, diet as the option and then a y_n column incidcating whether it was used, with 1 or 0.   Please help, I am so confused ... View more

Hi, I have a treatment variable with categories surgery, medication, other. Each person's treatment in the column looks like 'surgery+other' 'other+medication' etc. and I want to create individual columns for surgery, medication, and other that will mark the patient as having each type of surgery. How do i code this? ... View more