View Single Post
  #18  
Old 06-08-2009, 12:01 PM
Actuarialsuck Actuarialsuck is offline
Member
 
Join Date: Sep 2007
Posts: 6,119
Default

If anyone cares... Found the easiest solution, including a DISTINCT function in my SELECT statement. Basically as I noted the GROUP BY isn't useful since I'm not using functions (sum/count/etc.) in my SELECT so I can get rid of altogether and write something like:

proc sql;
create table data_table as
select distinct col_1, col_2
from big_table;
__________________
Quote:
Originally Posted by Buru Buru View Post
i'm not. i do not troll.
Reply With Quote
 
Page generated in 0.13936 seconds with 9 queries