Does anyone know if I could possibly shorten this up with a macro or something else? PROC SQL; CREATE TABLE J4 AS SELECT DISTINCT t1.pc, t1.CODE, (MAX(t1.JAN2010)) AS MAX_of_JAN2010, (MAX(t1.JUL2010)) AS MAX_of_JUL2010, (MAX(t1.NOV2010)) AS MAX_of_NOV2010, (MAX(t1.DEC2010)) AS MAX_of_DEC2010, (MAX(t1.JAN2011)) AS MAX_of_JAN2011, (MAX(t1.FEB2011)) AS MAX_of_FEB2011, (MAX(t1.MAR2011)) AS MAX_of_MAR2011, (MAX(t1.APR2011)) AS MAX_of_APR2011, (MAX(t1.MAY2011)) AS MAX_of_MAY2011, (MAX(t1.JUN2011)) AS MAX_of_JUN2011, (MAX(t1.JUL2011)) AS MAX_of_JUL2011, (MAX(t1.AUG2011)) AS MAX_of_AUG2011, (MAX(t1.SEP2011)) AS MAX_of_SEP2011, (MAX(t1.OCT2011)) AS MAX_of_OCT2011, (MAX(t1.NOV2011)) AS MAX_of_NOV2011, (MAX(t1.DEC2011)) AS MAX_of_DEC2011 FROM J3 t1 GROUP BY t1.pc, t1.CODE; QUIT;
... View more