About tan-wongv

tan-wongv · ‎05-24-2024

Thank you for your guidance! DMRN is like an ID. I don't have all the number since this is the subset from the original dataset.

tan-wongv · ‎05-24-2024

Thank you so much for your help! Could you also please help me with the code if I want to generate t1 t2 t3 and t4? The outcome would be: DMRN t1 t2 t3 t4 31 09MAY2017 30MAY2017 06APR2018 07FEB2019 33 02JUN2017 04DEC2017 11JUN2018 .

tan-wongv · ‎05-23-2024

I have a data set with DMRN and date of the visit (DX_Date). I would like to generate the the start and stop time or T1 and T2 based on each visit date. Could you please help me with the code? Here is how the data look like: DMRN DX_DATE 31 09MAY2017 31 30MAY2017 31 06APR2018 31 07FEB2019 33 02JUN2017 33 04DEC2017 33 11JUN2018 This is how I want to outcome be like: DMRN T1 T2 31 09MAY2017 30MAY2017 31 30MAY2017 06APR2018 31 06APR2018 07FEB2019 33 02JUN2017 04DEC2017 33 04DEC2017 11JUN2018

tan-wongv · ‎05-15-2024

Thank you very much for your help!

tan-wongv · ‎05-15-2024

I ran the following code and got the curve below. proc lifetest data=sasuser.combine_aim2n2 plots=survival(f) timelist=(0 to 132 by 12); time month2*ui2(0); run; Would there be a way to change the scale of x axis from 0 25 50 75 100 125 to 0 12 24 36 48 60 72 84 96 108 120 132?

tan-wongv · ‎04-28-2024

This code works for those who have UI = 0, new_date is equal to last_visit However, it did not work for those who have UI = 1, such as DMRN 31. I would like new_date for DMRN31 to be as 4MAY2021 4MAY2021 4MAY2021 DMRN last_visit UI recorded_time new_date 31 26AUG2021 0 06APR2018 26AUG2021 31 26AUG2021 0 16JAN2020 26AUG2021 31 26AUG2021 1 4MAY2021 4MAY2021 33 24MAY2022 0 02MAR2020 24MAY2022 33 24MAY2022 0 24MAY2022 24MAY2022 35 01DEC2014 0 25MAR2013 01DEC2014

tan-wongv · ‎04-28-2024

Thank you so much for your guide!! I found the problem as you said. I fixed it and now your code works 🙂

tan-wongv · ‎04-28-2024

Thank you so much for your response! I tried this code but the outcome just showed the observation where recorded_time is less than last_vist. It did not include the recorded_time that is equal to last_visit.

tan-wongv · ‎04-28-2024

I have a data set contains DMRN, last visit date, the presence of UI, and recorded date of UI. DMRN last_visit UI recorded_time 31 26AUG2021 0 06APR2018 31 26AUG2021 0 16JAN2020 31 26AUG2021 1 4MAY2021 33 24MAY2022 0 02MAR2020 33 24MAY2022 0 24MAY2022 35 01DEC2014 0 25MAR2013 I would like to create new_date for each DMRN based on these conditions: if UI = 1 then new_date = recorded_time else if UI = 0 then new_date = last_visit The outcome would be like as follow: DMRN last_visit UI recorded_time new_date 31 26AUG2021 0 06APR2018 4MAY2021 31 26AUG2021 0 16JAN2020 4MAY2021 31 26AUG2021 1 4MAY2021 4MAY2021 33 24MAY2022 0 02MAR2020 24MAY2022 33 24MAY2022 0 24MAY2022 24MAY2022 35 01DEC2014 0 25MAR2013 01DEC2014 Could you please help me with the code? Thank you very much

tan-wongv · ‎04-28-2024

I have a dataset contains DMRN, last visit date, the presence of UI, and recorded date of UI DMRN last_visit UI recorded_time 31 26AUG2021 0 06APR2018 31 26AUG2021 0 16JAN2020 31 26AUG2021 1 4MAY2021 31 26AUG2021 1 26MAY2022 33 24MAY2022 0 02MAR2020 33 24MAY2022 0 24MAY2022 35 01DEC2014 0 25MAR2013 35 01DEC2014 1 05JAN2015 I would like to keep only UI value and recorded_time that occurred before or equal to last_visit date for each DMRN. Could you please help me with the code?The outcome would look like this: DMRN last_visit UI recorded_time 31 26AUG2021 0 06APR2018 31 26AUG2021 0 16JAN2020 31 26AUG2021 1 4MAY2021 33 24MAY2022 0 02MAR2020 33 24MAY2022 0 24MAY2022 35 01DEC2014 0 25MAR2013

tan-wongv · ‎04-24-2024

Thank you so much!! I’m always grateful for your help 🙂

tan-wongv · ‎04-24-2024

I have a data set as follow. Dx_Date refers to the date of each visit. I would like to keep only sample who have >= 3 visits. In this case, only sample with DMRN 10 and 13 will be kept. What code should I use? Thank you DMRN DX_DATE Age 2 09MAY2022 73 4 09APR2021 58 10 01JAN2017 60 10 03FEB2018 61 10 06JUN2018 61 13 08FEB2017 70 13 09JUL2017 70 13 12MAR2019 72 13 25DEC2019 72

tan-wongv · ‎04-10-2024

Thank you so much for your help! I appreciate your explanation 😊

tan-wongv · ‎04-10-2024

I successfully grouped the diagnosis code into disease classes and label it as "yes" for each DMRN. This is how the outcome looks like: DMRN DX_CODE DX_NAME nervous circular respiratory genitourinary constipation DM 7 I10 hypertension Yes 7 J44.9 COPD Yes 7 M19.90 Arthritis 7 N40.0 BPH Yes Then, I would like to collapse the rows so that each DMRN has only one row and drop DX_CODE and DX_NAME. This is how I want the table look like: DMRN nervous circular respiratory genitourinary constipation DM 7 Yes Yes Yes What codes should I use? Thank you so much for your help.

tan-wongv · ‎04-02-2024

Thank you so much for your help!

Online Status	Offline
Date Last Visited	‎05-28-2024 04:08 AM

Re: Generate T1 and T2 base on visit date

Re: Generate T1 and T2 base on visit date

Generate T1 and T2 base on visit date

Re: change the scale of x axis of survival curve

change the scale of x axis of survival curve

Re: Create new date variable based on specific condition

Re: Keep only value and date that occurred before or at last visit dat...

Re: Keep only value and date that occurred before or at last visit dat...

Create new date variable based on specific condition

Keep only value and date that occurred before or at last visit date

Re: change the scale of x axis of survival curve

Re: Keep only sample with at lease 3 visits

A Guide to Logistic Regression in SAS

Re: Assign the same value to identical IDs with date difference less t...

Re: Assign the same value to identical IDs with date difference less t...

Re: Keep only sample with at lease 3 visits

Re: Generate T1 and T2 base on visit date

Re: Generate T1 and T2 base on visit date

Generate T1 and T2 base on visit date

Re: change the scale of x axis of survival curve

change the scale of x axis of survival curve

Re: Create new date variable based on specific condition

Re: Keep only value and date that occurred before or at last visit dat...

Re: Keep only value and date that occurred before or at last visit dat...

Create new date variable based on specific condition

Keep only value and date that occurred before or at last visit date

Re: Keep only sample with at lease 3 visits

Keep only sample with at lease 3 visits

Re: Group diagnosis code into disease classes

Group diagnosis code into disease classes

Re: Assign the same value to identical IDs with date difference less t...