Hi Paige, yes I would need 52 columns. I can't think of another way to correlate the initial status volume to the change in status through the weeks. The proc freq would only get me there partly... It is still missing the total ID count for each status week. So, I am trying this, but was wondering if there is a faster method to get to the same kind of output PROC SQL; CREATE TABLE TT2 AS SELECT Year,Status_WEEK,COUNT(ID) AS TOTAL, CASE WHEN (MEMO_WEEK = 1 AND MEMO_TYPE = 'M' THEN ID END) AS MEMO_WEEK_1, CASE WHEN (MEMO_WEEK = 2 AND MEMO_TYPE = 'M' THEN ID END) AS MEMO_WEEK_2, CASE WHEN (MEMO_WEEK = 3 AND MEMO_TYPE = 'M' THEN ID END) AS MEMO_WEEK_3, ... AND SO ON FOR ALL 52 WEEKS from tt1 group by Year,Status_week; quit;
... View more