Trinath Panda的动态

查看Trinath Panda的档案,图片

Clinical Data Scientist | Python | SAS | CDISC | SDTM | SQL | MACRO | ADaM | TLFs | MS in Clinical Research |

In this post, I'll explain Date and Time imputation, a crucial process in data analysis. Date imputation converts partial dates in datasets like ADCM, ADAE, and ADMH to complete dates, addressing data collection issues. FOR START DATE (—STDTC): - If the day is missing (e.g., CMSTDTC? 2007-03), impute the 1st day of the month (e.g., ASTDT? 2007-03-01) and set the imputation flag to ‘D’. - If the month is missing (e.g., CMSTDTC? 2007-__-07), impute the 1st month of the year (e.g., ASTDT? 2007-01-07) and set the flag to ‘M’. - If both month and day are missing (e.g., CMSTDTC? 2007), impute the 1st day of the year (e.g., ASTDT? 2007-01-01) and set the flag to ‘M’. - If the date is entirely missing, keep the subject's treatment start date (e.g., 2007-03-07) and set the flag to ‘Y’. FOR END DATE (—ENDTC) -If the day is missing (e.g., CMENDTC? 2007-03), impute the last day of the month (e.g., ASTDT? 2007-03-31) and set the flag to ‘D’. -If the month is missing (e.g., CMENDTC? 2007-__-07), impute the last month of the year (e.g., ASTDT? 2007-12-07) and set the flag to ‘M’. -If both month and day are missing (e.g., CMENDTC? 2007), impute the last day of the year (e.g., ASTDT? 2007-12-31) and set the flag to ‘M’. -If the date is entirely missing, keep the subject's treatment end date (e.g., 2007-03-07) and set the flag to ‘Y’. Visit my website for more details. Link- https://lnkd.in/gM7ZNz9R #ADAM #sdtm #sap #cdisc #DataAnalysis #ClinicalData #SASProgramming #DataImputation #ClinicalResearch #SASJobs #DataScience #ClinicalTrials #JobSeeker #DataAnalytics #CareerOpportunity #HealthcareJobs #ClinicalSAS #ImputationRules #JobSearch #DataManagement #OpentoWork #JobHunt #SASAnalyst #CareerGrowth #JobOpportunity #DataQuality #DataProcessing #EmploymentOpportunity #DataAccuracy #SASDeveloper #HiringNow #JobOpening #SASCertification #OpentoNewOpportunities

Date & Time Imputation Variable

Date & Time Imputation Variable

trinathpanda.blogspot.com

Payal Rajput

Research Assistant, Indian Council of Medical Research (ICMR)

8 个月

Thanks for sharing.. Keep it up

回复

要查看或添加评论,请登录