Hi there,   For your kind information, I am analysing a dataset having patient's records related to his duration of stay in hospital. Some patient may have multiple records of admission during the same visit created by different departments of the same hospital. I am trying to remove all records which are reflecting part of the total duration of stay. For e.g id 101 having one record showing duration of stay from 20160110 to 20160120 whereas other records created by a department shows duration of stay from 20160115 20160118 which is actually part of his total stay. I want to delete the second record. Can some body help me to address this.  data have; input id adm_date dis_date site ; cards; 101 20160110 20160120 1234 101 20160115 20160118 1235 101 20160125 20160128 1235 102 20160110 20160118 1234 102 20160110 20160112 1235 ; run; data want; input id adm_date dis_date site ; cards; 101 20160110 20160120 1234 101 20160125 20160128 1235 102 20160110 20160118 1234 ; run; Thank you in advance for your kind reply. Regards,   ... View more

Hi there, For your kind information, I am trying to create a report where the mean, median and P90 will be presented for each month as follows:     year                 jan                                      feb                                  mar                         apr                                mean median p90         mean median p90    mean median p90     mean median p90     2011          2           3         7             3           4        8        4           5        7            3        5       7          My current table as follows: data have; input year month $ mean median p90 ; cards; 2011 jan 2 3 7 2011 feb 3 4 8 2011 mar 4 5 7 2011 apr 3 5 7 2011 may 3 6 8 2012 jan 3 5 7 2012 feb 3 6 8 2012 apr 3 5 7 2012 may 3 6 8 ; run; Thank you in advance for your kind help. Regards,   ... View more

Hi there, I am trying to crreate a table having summary of report submitted in each month and experiencing some problem. Can somebody help me to overcome the obstacle. Sample of the table,  I am havcing as well as I am expecting are given below. Thank you in advance for your kind reply.  data have; input id mon $ count ; cards; 101 jan 10 101 feb 20 101 mar 25 101 jun 20 102 jan 10 102 feb 20 102 Apr 25 102 may 20 103 Apr 10 103 feb 20 103 mar 25 103 may 20 103 jul 25 ; run; data want; input id jan feb mar apr may jun jul; cards; 101 10 20 25 . . 20 . 102 10 20 . 25 20 . . 103 . 20 25 10 20 . 25 ; run; Regards,   ... View more