Here is the log: 493 proc sql; 494 create table ASH.DOM as 495 Select ID, car_code as dominant, MKTSHR from ASH.DATAN group by ID HAVING MKTSHR=MAX(MKTSHR); NOTE: The query requires remerging summary statistics back with the original data. NOTE: Table ASH.DOM created, with 24442 rows and 3 columns. 496 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.11 seconds cpu time 0.14 seconds Also, I use that column to make further calculations in another program, and that program actually retrieves the values named "dominant" but in my datasets the name of the variable is still car_code. For example, proc sql; create table ASH.Datao as Select a.*,b.dominant from ASH.Datan as a left outer join ASH.DOM as b on a.ID=b.ID; quit;
... View more