DATA TEST; INPUT CUST A B C; CARDS; 1 12 13 14 1 12 13 11 2 12 10 14 2 12 17 14 3 10 16 11 3 10 13 14 4 12 11 14 4 12 11 14 ; RUN; /*the objective is to get aggregated max values per cust, and resulting one column which have max of a,b and c*/ /*this codes gives var wise aggregated max values but when i try to find for all a,b,c it gives error*/ PROC SQL; CREATE TABLE ANA AS SELECT CUST ,MAX(A) as max_a ,MAX(B) as max_b ,MAX(C) as max_c from test group by 1 ;quit; PROC SQL; CREATE TABLE ANA AS SELECT CUST ,MAX(max_a,max_b,max_c) as max_abc from test ;quit;
... View more