thanks, works perfectly. Fine with the note 🙂 ... View more

thanks, Ksharp, this worked! ... View more

HI LinusH, thank you for your response. I tried your code and it created a table but returned all 0 values to the HTID. Other ideas?   Also,I think you are right about storing the indicator variable onthe last id row, so what is a better alternative? Thanks! ... View more

thanks, worked perfectly! ... View more

thanks, this worked too! I ended up using the Macro in the end but just checked it against your code which was great. Thanks! ... View more

Thank you. So that will just give me a unique ID. But what about then reshaping VISIDATE? Especially since I want to transpose multiple variables (var4_visit1, var4_visit2, etc. ) by visitdate? Any idea if that is possible? THanks again. ... View more

Hi Patrick,    Please note that the HTID is the SAME for 2 people (based on a couples study) so I am trying to make individual IDs and you have to do this by sorting by htid and sex. Also note there are multiple observtaion (rows) for each member of the couple (HTID) at different times. Also the variables are unfortuantely not named in a way where I can use an array var1-var25 so will likely need to rename them temporarily to get the data in shape.   Example data have: HTID SEX AGE VISITDATE       var4   var5    var6....var200 5014 M     35      10march2002 5014 M     35       02june2002 5014 M     35       18sept2002 5014 M     35       02jan2003 5014 F     30       10march2002 5014 F     30       26june2002 5023 M    28       20june2003 5023 M    28       21sept2003 5023 M    28       5jan2004   Example data want: each individual with their own row with each visitdate as an unique event   ID  HTID  SEX AGE  VISITDATE1    VISITDATE2    VISITDATE3..... 1   5014  M     35      10march2002  02june2002     18sept2002 2   5014  F      30      10march2002   26june2002 ...     Eventually, after descriptive stats, etc. I will be be perfoming some multivariate logistic regressions and build marginal structural models etc. ... View more

HI there, thanks for replying. To answer your Qs:   1) Please note that the HTID is the SAME for 2 people (based on a couples study) so I am trying to make individual IDs and you have to do this by sorting by htid and sex. Also note there are multiple observtaion (rows) for each member of the couple (HTID) at different times. Also the variables are unfortuantely not named in a way where I can use an array var1-var25 so will likely need to rename them temporarily to get the data in shape.   Example data have: HTID SEX AGE VISITDATE       var4   var5    var6....var200 5014 M     35      10march2002 5014 M     35       02june2002 5014 M     35       18sept2002 5014 M     35       02jan2003 5014 F     30       10march2002 5014 F     30       26june2002 5023 M    28       20june2003 5023 M    28       21sept2003 5023 M    28       5jan2004   Example data want: each individual with their own row with each visitdate as an unique event   ID  HTID  SEX AGE  VISITDATE1    VISITDATE2    VISITDATE3..... 1   5014  M     35      10march2002  02june2002     18sept2002   2   5014  F      30      10march2002   26june2002 ...     2) I am happy to write variable names if that is the only way, I just wasn't sure. I thought maybe it would be easier to rename them to some convention like var1-var200 in order to get the data in shape first with arrays, etc.   Eventually, after descriptive stats, etc. I will be be perfoming some multivariate logistic regressions and build marginal structural models etc. ... View more