Hi, Is there a way to find out the observation number of duplicate record . I tried with _n_ but somehow am unable to find the exact row number. Need some help in that data source; input a b c d; cards; 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 9 10 11 12 5 6 7 8 ; run; I want target as a b c d Dup_row_num 1 2 3 4 4 5 6 7 8 6 9 10 11 12 5 I tried following , I know I need to combine these two queries but somehow is unable to find it proc sql; create table t1 as select monotonic() as row_number,a,b,c,d from source ;quit; proc sql; select max(row_number) from ( select count(*) as cnt, a,b,c,d, row_number from t1 group by a,b,c,d ) ; quit; Thanks in advance
... View more