Hi everyone, I have a dataset with over 15 million entries. I'm looking to compare the row below with the one above to look for all unique ID's that have a different value next to them. For example: AB1234567, 145633431 AB1234567, 145633431 AB1234568, 145633431 AB1234568, 145633432 AB1234566, 145631513 AB1234565, 145635315 In this case, I am creating a counter or loop to look for all unique ID's that appear twice, but have a different value. In this case the only one is AB1234568. I want to ignore AB1234567 because it has the same value next to it both times. I tried using a counter already and was able to find all values that came up twice but it was very inefficient and did not solve my problem: Proc summary DATA=AUTO NWAY MISSING; class NIV nopol; VAR xyz; OUTPUT OUT=DOUBLES(DROP=_TYPE_ _FREQ_) sum= ; RUN; proc sort data=DOUBLES; by NIV NOPOL; run; DATA AUTO2; SET DOUBLES; IF XYZ=2; RUN; I have not used loops in SAS before but I am setting them up by using other people's code as an example. If anyone can help it's appreciated. Thanks
... View more