BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
haoduonge
Quartz | Level 8

Hi All,

I don't know a right topic for my question. Hope it reaches many of you.

I have been in the forum asking on counting process survival analysis.

I have made some progress on it. Thanks for the help!

I posted one question on merging variables which have different time interval (T1,T2). I guess it is tricky for everyone.

So I split time (start, stop) of one variable into interval (T1, T2) that can be matched with other variables.

Below in table1 is the original one with treatment, start and stop, and outcome.

And I split start and stop time in table 2 (T1,T2) so I can merge it with other variables.

I hope that the result will be similar, but it is not: HR using table 1 is slightly larger than that from table 2. 

I really appreciate if any could have explanations and how to adjust it?

Thank you!

Hao  

 

Table 1

IDstartstopoutcometreatment
100.000100
10.00012.21801
200.000100
20.00012.77901
302.10500
405.09200
45.0926.4701
503.53200
53.5326.49401
603.60300

Table 2

IDstartstopoutcometreatmentT1T2
100.00010001
10.000110101
1120112
122.2180122.218
200.00010001
20.000110101
2120112
222.7790122.779
3010001
3120012
322.1050022.105
4010001
4120012
4230023
4340034
4450045
455.0920056
45.09260156
466.470166.47
5010001
5120012
5230023
533.5320034
53.53240134
5450145
5560156
566.4940166.494
6010001
6120012
6230023
633.6030034
63.60340134
6450145
6560156
666.470166.47
1 ACCEPTED SOLUTION

Accepted Solutions
sbxkoenk
SAS Super FREQ

Hello @haoduonge ,

 

I see your question already has been answered successfully on the 'Statistical Procedures' board.

Great!

Maybe a good idea to mark this thread as solved as well, such that people don't lose time opening and reading it.

 

Thanks,

Koen

 

View solution in original post

3 REPLIES 3
sbxkoenk
SAS Super FREQ

Not sure why you have put this in the 'SAS Text and Content Analytics' board.

'Statistical Procedures' board looks more relevant to me.

 

Anyway, you say:

> I hope that the result will be similar, but it is not: HR using table 1 is slightly larger than that from table 2. 

What is HR? Hazards Regression, Human Resources? 😉

And what survival analysis model / procedure are you using? PROC PHREG?

 

Can you show us pieces of the output where you indicate the differences and why you think they shouldn't be there?

 

Thanks,

Koen

haoduonge
Quartz | Level 8

Koen,

I reposted it under 'Statistical procedures' as your suggestion and added more information on it.

Thanks!

Hao

 

sbxkoenk
SAS Super FREQ

Hello @haoduonge ,

 

I see your question already has been answered successfully on the 'Statistical Procedures' board.

Great!

Maybe a good idea to mark this thread as solved as well, such that people don't lose time opening and reading it.

 

Thanks,

Koen

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1475 views
  • 0 likes
  • 2 in conversation