Hi , Can you let me know how to get Max  & Min value  for rows in proc sql data a1; input num maths phys chemis; datalines; 1 19 23 45 2 33 45 55 3 56 88 56 ; run; Looking for Output num max 1       45 2        55 3        88 Regards, Vnky ... View more

data a1; input sno name $ sal; datalines; 1 jagan 300 2 Karti   400 3 Vankat 500 2 jagan 300 2 Karti   400 3 Vankat 500 ; run; data a2; input month$ sno role$; datalines; jan 1 Clerk Feb 2 Cook Nar 3 Account ; run; Looking for output: Sno  name   sal       jan           feb   1       jagan  300     clerk         cook 2       Karti    400    cook         cook 3      venkat  500    accounts  Accounts Note: For every new month I must  get a new column(one month lag). Ex If I'm in month of april I must fill there roles for month march  and column name as march. Below is the query which i wrote but i'm getting error proc sql; create table a3 as select a.*, case when sno in (select sno from a2 where month='jan')           then ( select b.role from a1 as a left join a2 as b             on a.sno=b.sno)    else '#n/a' end as Jan from a1 as a; quit; Please help out to solve this issue  ... View more