Hi All, I have a question on adding observations that are the same: My dataset (see below) has date_time, Name1, name2, name3 and a vehicle number. I want to add all the observations from the same vehicle number on the same date for that person.   Date_Time                         Vehicle            Name1                 Name2             Name3 2019-09-13 20:18        1293          John Doe       Jane Doe 2019-09-13 20:47        1293          John Doe       Jane Doe 2019-09-13 22:18        1293          Jane Doe       John Doe 2019-09-23 00:50               1292             John Doe           John Smith 2019-09-24 00:02               1293             John Doe           Jane Smith          Alex Doe 2019-09-24 20:16               1293             John Doe           Ben smith 2019-09-25 02:52               1293             John Doe           Ben smith   From the table above, the bold ones are on the same date, same vehicle and same names. I want to count them as 1 incident on that date for that person with that vehicle number.   Can someone help me with that! Not sure how to write a program for that.   Thank you, M     ... View more

Hi All, I have a question with merging two datasets. I want to merge table A with table B and get all the observations in table A that doesn't match with table B. I don't want the matched observations. I have something like this for all matched observations from table A and matching with table B.   DATA matched1; MERGE test1(IN = a) test2;     BY  gender age;  IF a; RUN;   I know this gives all the observations from test1 and those matching from test2. But I want the non-matched one, can I do something like this:   DATA matched1; MERGE test1(IN = a) test2(in=b);     BY  gender age;  IF a and not b; /*Not sure if this is the right statement to use in SAS*/ RUN;   Please advise!   Thank you, Malathi   ... View more