I have a daily transactional data for 2 years and I need to have a summary view like below. The status code is always "B" and the Memo code is always "M" Status represents initial status of the ID. Memo represents final status of the ID   Data looks like:    ID Status Status Date Memo Memo_Date Status Week Memo_Week 1 B 01-Jan M 01-Jan                     1                       1 2 B 01-Jan M 02-Jan                     1                       1 3 B 01-Jan M 02-Jan                     1                       1 4 B 01-Jan M 10-Jan                     1                       2 5 B 02-Jan M 10-Jan                     1                       2 6 B 02-Jan M 14-Jan                     1                       3 7 B 02-Jan                         1   8 B 02-Jan M 03-Jan                     1                       1 9 B 10-Jan                         2   10 B 10-Jan M 14-Jan                     2                       3   What i need to do is summarize like this below. the intent is to show the % of status B from a given week that move to status B in week 1,2,3 etc.      ID count Memo_Week_1 Memo_Week_2 Memo_Week_3  1  8 3 2 2   2  2 0 0 1   What i am thinking of doing is writing a proc sql like below   select status_week, count(ID) as ID_ count, case when (memo_week = 1 then ID end) as Memo_Week_1, case when (memo_week = 2 then ID end) as Memo_Week_2   and so forth. But this mean i have to hardcode all 52 weeks. There has to be a more efficient way to do this?   Thanks,   ... View more