My current data is below. I would like to create a new column called 'median for category+date', where it is equal to the median by date and category. That is order the dataset by date and category and then compute the median and store it in the column 'median for category+date'. current: Date Category Value 1-Jan-19 C 17 1-Jan-19 B 21 1-Jan-19 B 12 1-Jan-19 B 12 1-Jan-19 A 17 1-Jan-19 A 6 1-Feb-19 D 19 1-Feb-19 C 23 1-Feb-19 D 24 1-Feb-19 D 21 1-Feb-19 A 16 1-Mar-19 A 9 1-Mar-19 D 24 1-Mar-19 D 15 1-Mar-19 A 7 1-Mar-19 D 21 1-Mar-19 D 5 1-Apr-19 C 9 1-Apr-19 A 15 1-Apr-19 A 5 1-Apr-19 C 15 1-Apr-19 A 19 1-May-19 D 17 1-May-19 C 9 1-May-19 A 7 1-May-19 B 13 1-May-19 C 10 1-May-19 A 14   desired: Date Category Value Median for category+date 1-Jan-19 A 17 11.5 1-Jan-19 A 6 11.5 1-Jan-19 B 21 12 1-Jan-19 B 12 12 1-Jan-19 B 12 12 1-Jan-19 C 17 17 1-Feb-19 A 16 16 1-Feb-19 C 23 3 1-Feb-19 D 19 21 1-Feb-19 D 24 21 1-Feb-19 D 21 21 1-Mar-19 A 9 8 1-Mar-19 A 7 8 1-Mar-19 D 24 18 1-Mar-19 D 15 18 1-Mar-19 D 21 18 1-Mar-19 D 5 18 1-Apr-19 A 15 15 1-Apr-19 A 5 15 1-Apr-19 A 19 15 1-Apr-19 C 9 12 1-Apr-19 C 15 12 1-May-19 A 7 10.5 1-May-19 A 14 10.5 1-May-19 B 13 13 1-May-19 C 9 9.5 1-May-19 C 10 9.5 1-May-19 D 17 17 ... View more

If the ID from data set 1 exists in dataset 2, I would like to create a new variable called flag in dataset 2 and it =1 and =0 otherwise. This is shown below. I tried using merge, but couldn't find a good way to do this. any help would be great.   Data 1: ID X1 X2   54 9 3   55 3 2   56 2 0   57 4 4   58 4 1   59 6 8   60 1 7   Data 2: ID Y1 Y2 Y3 54 55 79 55 55 83 61 55 56 74 77 60 57 64 88 56 60 87 78 83 61 84 87 77 62 78 68 50 63 89 59 52 64 74 77 60 65 55 79 55   Desired data: ID Y1 Y2 Y3 FLAG 54 55 79 55 1 55 83 61 55 1 56 74 77 60 1 57 64 88 56 1 60 87 78 83 1 61 84 87 77 0 62 78 68 50 0 63 89 59 52 0 64 74 77 60 0 65 55 79 55 0 ... View more

Dataset 1 ID CC1 CC2 111 4 4 111 2 3 111 2 4 112 4 2 112 2 0 113 0 2 114 4 4 115 1 1 116 1 1 117 2 2 118 3 2 119 1 4 120 2 1 121 5 5 122 2 1   Data set 2 ID CC3 111 0 111 2 111 4 112 1 112 2 144 5 145 5 146 5 140 1 141 1 117 2   I would like to calculate what I call the 'match' rate between the distinct ID's of the two datasets. In this case the match rate for 2 (how many disitnct id's from 2 are in 1) is = 3/8 And the match rate for 1 (how many distinct id's from 1 are in 2) is = 3/12   I thought of doing something like a inner join, but I can't completely work it out. ... View more

I have to following dataset that I want to summarise in SAS. Attached below is my desired data set. In excel I would make a pivot table, however I am not sure what commands I would use in sas to reach my desired data. I am new to SAS. Thanks   ID Date Amount 38134805 1/04/2017 53 38257051 1/04/2017 54 38263562 1/04/2017 91 38335667 1/04/2017 76 38368668 1/04/2017 111 38373205 1/04/2017 103 38375879 1/04/2017 50 38385977 1/04/2017 85 38134805 1/05/2017 117 38257051 1/05/2017 91 38263562 1/05/2017 59 38335667 1/05/2017 107 38368668 1/05/2017 85 38373205 1/05/2017 87 38375879 1/05/2017 118 38385977 1/05/2017 62 38134805 1/06/2017 115 38257051 1/06/2017 52 38263562 1/06/2017 58 38335667 1/06/2017 61 38368668 1/06/2017 102 38373205 1/06/2017 59 38375879 1/06/2017 113 38385977 1/06/2017 51   ... View more