View Single Post
  #62  
Old 05-24-2011, 05:50 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,708
Blog Entries: 2
Default

Adoubledot's got the right answer. Another way is

proc sql;
create table table2 as
select *
from table 1
group by pol
having iteration=max(iteration);
quit;

but with 1M+ rows, this will be really inefficient.
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote
 
Page generated in 0.08689 seconds with 9 queries