I have a dataset as shown in Table 1. I want to separate this dataset into two datasets made up of only Previous visits for each of the IDs present, and another dataset for only the visits after the index date for each ID. It’s important to have all ids whether they had a visit or not so each ID can be compared in the previous vs after phases of treatment. A little stumped on how to go about this, any help would be appreciated!   Table 1: ID Visit date Index date Previous visits label After index label 1 . Jun7,2005 . . 2 Jan3,1999 Apr8,1999 1 0 3 Jan3,1999 Jan1,1998 0 1 4 Oct7,2002 Sept10,2001 0 1 4 Jun1,2001 Sep10,2001 1 0     Wanted datasets: Dataset A (Previous visits) ID Visit date Index date Previous visits label 1 . Jun7,2005 . 2 Jan3,1999 Apr8,1999 1 3 . Jan1,1998 . 4 Jun1,2001 Sep10,2001 1    Dataset 2 (After index visits) ID Visit date Index date After index label label 1 . Jun7,2005 . 2 . Apr8,1999 . 3 Jan3,1999 Jan1,1998 1 4 Oct7,2002 Sep10,2001 1 ... View more

This is a previously unanswered question, hoping someone can help!   If I have the following data let’s say with some duplicate injury dates. My goal is to keep the most severe of the duplicate injury dates along with the other unique injury records. The hierarchy is as follows: Home(least severe)<Clinic<Hospital(more severe). So I would keep only the Clinic observation for ID 1, but for ID 2 I would keep the Clinic on the Feb 1st injury date (as it is more severe than Home for the same injury date) and the Feb 6th date since it’s another injury date and not a duplicate. How do I code this?   ID Injury date Location of injury 1 Jan02,2007 Home 1 Jan02, 2007 Clinic 2 Feb01,2000 Home 2 Feb06,2000 Hospital 2 Feb01,2000 Clinic ... View more

Hi, this is a question that has evolved out of curiosity…just learning SAS! If you see the table below there are duplicates and assuming there is a hierarchy, I would want to retain the most severe case on the duplicate injury date in the order of Home(least severe)<Clinic<Hospital(more severe). How would I go about retaining only the most severe case if the injury date is the same?   ID Injury date Location of injury 1 Jan02,2007 Home 1 Jan02, 2007 Clinic 2 Feb01,2000 Home 2 Feb01,2000 Hospital 2 Feb01,2000 Home ... View more

Hi I have two datasets that I would like to merge by id, but when I do that, I have Dataset B overwriting the diagnosis date, cluster and servdate in Dataset A, how do I prevent this?   Dataset A: ID Diagnosis Date Cluster Servdate 1 Jan 1 1998 Urban Aug 3 1998 1 Jan 1 1998 Urban Aug 15 1998 2 Feb 3 2000 Urban April 9 2000   Dataset B: ID Diagnosis Date Cluster Servdate 1 Jan 1 1998 Rural Sept 1 1998 1 Jan 1 1998 Rural Sept 3 1998 2 Feb 3 2000 Rural May 7 2000 ... View more