I hope you are doing well. I am trying to calculate person years. I am not sure if there is any code we can use in proc phreg to get person year and number of events directly.
I also have another question. I selected participants who did not have health outcome and try to calculate person year by hand. I was wondering if there is any code I can use to get the sum of each product of each column* time: h:persist good person time=2*176+4*340+6*272+.......
If you can't manage that at least post the example as simple text in a text box. That particular tabular layout is not worth trying to write a data step with.
My first thought would be Proc Means/ summary with your Time variable as a Weight variable and then request a Sum for the other variables. DO not include the Total row, if you have such in your actual data set, as it is obviously not a numeric variable and a Weight variable must be numeric.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.