Thank you for your help. I have updated the dataset for clarity. Each record is for a specific timestamp , RECORDED_DATE ID is the record number (unique to each patient) enc is the hospital encounter number for a particular visit Time1 is the admission time Time2 is the discharge time Creat_cat is creatinine as a dichotomous variable (<1.8 and >1.8) PT_cat is a dichotomous variable (<300 and >=300) If a patient (ID) has Creat_cat >1.8 or PT_cat <300 for more than 48hours at anytime between Time1 and Time2 (during admission), I would like to classify them as 'severe'. If a patient (ID) has Creat_cat >1.8 or PT_cat <300 for less than 48hours at anytime between Time1 and Time2(during admission), I would like to classify them as 'moderate'. If a patient (ID) does not satisfy either condition (of time), I would like to classify them as mild.
... View more