hello astounding, that is exactly what I need. I get this error when I run it 5775 /*then process each DATE2 separately:*/ 5776 data yedek; 5777 date_counter = 0; 5778 do until (last.date2); 5779 set a5; 5780 by date2; 5781 date_counter + 1; 5782 end; 5783 group_counter = 0; 5784 do until (last.date2); 5785 set a5; 5786 by date2; 5787 group_counter + 1; 5788 group = ceil(group_counter / date_counter * 20); 5789 end; 5790 output; 5791 end; --- 161 ERROR 161-185: No matching DO/SELECT statement. 5792 5793 drop group_counter record_counter; 5794 5795 run; WARNING: The variable record_counter in the DROP, KEEP, or RENAME list has never been referenced. chris, thanks for taking your time to do this, but I don't think you read my previous posts. you are ignoring the ranking variable. I want to rank each month into 20 equal sized groups.
... View more