My Table has 12k columns and 72 rows table sorted by id and type. If table grouped by single variable, i can be use monotonic for min and max row. But table grouped by two variable. So, i can not use monotonic for min and max for groups. My table like: ID TYPE NAME GPA CREDIT FACULTY DEPARTMANT SCHOLARSHIP CLUB_FLAG … 13416 T1 Micheal 3.00 93.00 ENG. FAC. COMP.ENG. 1 0 … 13416 T3 Micheal 3.00 93.00 ENG. FAC. COMP.ENG. 0 0 … 13417 T2 Sam 1.68 123.00 ENG. FAC. COMP.ENG. 1 0 … 13418 T1 Keanu 3.51 135.00 ENG. FAC. COMP.ENG. 1 0 … 13418 T2 Keanu 3.51 135.00 ENG. FAC. COMP.ENG. 0 1 … 13418 T4 Keanu 3.51 135.00 ENG. FAC. COMP.ENG. 0 1 … 13419 T3 Ann 1.85 84.00 ENG. FAC. COMP.ENG. 0 0 … 13420 T4 George 2.10 27.00 ENG. FAC. COMP.ENG. 0 0 … 13421 T1 Jennifer 0.41 112.00 ENG. FAC. COMP.ENG. 1 1 … 13421 T2 Jennifer 0.41 112.00 ENG. FAC. COMP.ENG. 0 1 … 13422 T1 Ann 2.13 37.00 ENG. FAC. COMP.ENG. 0 1 … 13422 T2 Ann 2.13 37.00 ENG. FAC. COMP.ENG. 0 0 … 13422 T3 Ann 2.13 37.00 ENG. FAC. COMP.ENG. 0 0 … 13422 T4 Ann 2.13 37.00 ENG. FAC. COMP.ENG. 1 1 … … … … … … … … … … … Thank you for your answers @PaigeMiller @Astounding @Ksharp . I have to writed by PROC SQL.
... View more