1 2 Previous Next 15 Replies Latest reply on Jul 30, 2017 1:14 AM by hannah.rhrbein

    To identify patients with at least once the same diagnosis as recorded on Cause of Death

    hannah.rhrbein

      Hi everybody,

       

      I've got a problem to create a new variable again. Maybe you can help me.

      An example of the dataset (hospital):

       

      Patientnumber
      Casenumber
      Discharge date
      Cause of Discharge
      Diagnosis
      11113.03.2014treatment regularly endsR57.9
      11220.02.2016deathR57.9
      22111.01.2013treatment regularly endsM54.5
      22223.05.2014treatment regularly endsI50.00
      22302.12.2014death

      I50.00

       

      I'd like to identify the patients, who were admitted to hospital within the last 12 months of life at least once for the same diagnosis as recorded on Cause of Death (Cause of Discharge: death). In the example Patient number 2.

      If "within the last 12 months of life" is a problem, it would be also great to know how to identify patients, who were admitted to hospital at least once for the same diagnosis as recorded on Cause of Death (in the example both patients)

       

      I hope it's possible.

      Thanks in advance!

        1 2 Previous Next