推 anniecs: proc sql; 04/16 02:01
→ anniecs: create table MoreThanOne as 04/16 02:01
→ anniecs: select * 04/16 02:01
→ anniecs: from OldData 04/16 02:01
→ anniecs: where name not in 04/16 02:01
→ anniecs: (select name from Oldata group by name having count(* 04/16 02:01
→ anniecs: )=1); 04/16 02:01
→ anniecs: quit; 04/16 02:01
推 mkopl: 先sort，然後篩not(first.id =1 & last.id =1) 04/16 18:52
推 ninjaying: proc sort nouniquekey 04/19 12:45
推 j1990312: m大是對的，我記得要再加上 by id 04/23 12:19