I am hoping to find a way to automatically create a dataset in SAS that I can use for Extended Cox Proportional Hazard regression using time-varying covariates.   I have a dataset in the current format - albeit it this is simplified to aid understanding of my question! ID  Censored  SurvT(yrs) Start_Yr  End_Yr  +static Xn 1       0                      5          2010       2014 2       0                     10         2005       2014 3       1                      8          2005       2012   I have a separate dataset that contains GDP growth for each of the years 2005-2014. I want to merge these two datasets, and create a new dataset in the following format (so effectively each ID has multiple observations, representing each year with a different value for GDP growth): ID    Censored    Age(yr)     Yr     GDP_growth   +static Xn 1         0                      1      2010       -0.5% 1         0                     2      2011       +0.25% 1         0                       3      2012        +1% 1         0                       4      2013       +0.25%   Can anyone advise how I should go about this in SAS and if it is even possible?!  I have over 6000 IDs in my dataset, some with timeperiod of over 10 years, so I don't want to create this data manually!   Thank you   ... View more

I'm a relatively new SAS user, and looking for help to re-organise/summarise my data. I have data on the gender of each Director in a series of firms, in the format:   FIRM ID          GENDER 1                           M 1                           M 1                           F 2                           M 2                           F   I want to be able to summarize and transpose this data, so I have only one observation per firm, and a count of how many male and female directors.  So the resulting format would look like:  FIRM ID               MALE                 FEMALE 1                           2                         1 2                           1                         1 I'm wondering if I can use PROC TRANSPOSE for this, but can't figure out how to do this together with a count of male/female.   Grateful for any guidance/suggestions!  ... View more