Hello my advisor; 1. First request: I tried the second code you recommended to me in the last message but it didn't solve the problelm. The system returned the error below, "The format $date was not found or could not be loaded" This variable when I run proc contents to see its attributes , it shows that type (charcter variable) with a lenght of 8. The second issue assistance in the data i presented in my original post as seen below' 2. Second request; I wish also to create a variable with patients who have been positively diagnosed more than 3 times as the true POSITIVE result ( to be coded as 1) and the rest { combine those with less than 3 times of positive diagnosis + Those with negaive diagnosis(o) as Truly NEGATIVE result. That is to say some one with positive diagnosis only twice or less to be considered as [HEALTH coded as 0} and those with more than 3 times of postive diagnosis as Truly {SICK coded as 1}. This data is longitudinal with many repaeted observations on different dates and i want to retain all information of the patients but group them as diseases and health according to the above criteria to conduct survival analysis. I will be glad to recieve more advise about those two problems above. Thank you very uch for the continued assistance.
... View more
