About tan-wongv

tan-wongv

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

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

tan-wongv

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

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

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

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

tan-wongv

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!

tan-wongv · ‎04-02-2024

Thank you so much for your response!

tan-wongv · ‎03-31-2024

Thank you so much!

tan-wongv · ‎03-31-2024

I would like to replace missing value with closest value from the same DMRN, but the dx_date should be less than 365 days. This is how my data look like: DMRN dx_date BMI 30 04FEB2013 35.82 30 04JUN2013 . 30 04NOV2014 26.55 25 22JAN2016 30.42 25 25MAR2022 . This is how I want it to be; DMRN dx_date BMI 30 04FEB2013 35.82 30 04JUN2013 35.82 30 04NOV2013 26.55 25 22JAN2016 30.42 25 25MAR2022 . What codes should I use?

tan-wongv · ‎03-24-2024

Thank you very much for your response! How about if I want to keep the data with smallest date difference, but the difference should not be more than 365 days? Can you please also help me with this issue?

tan-wongv · ‎03-24-2024

Thank you for your response! I have actually tried this before. After this method, I would like to keep only the value of ADL that has number of days between recorded_time and Dx_date less than 365 days, but I don't know which code should I use.

Online Status	Online
Date Last Visited	10 seconds ago

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...

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: How do I merge two dataset and keep the data with smallest date di...

Re: Keep only sample with at lease 3 visits

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...

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

Re: How do I merge two dataset and keep the data with smallest date di...

Assign the same value to identical IDs with date difference less than ...

Re: How do I merge two dataset and keep the data with smallest date di...

Re: How do I merge two dataset and keep only the data with smallest da...