For example, for CT_KEY=7, you summarized change CR_ST_NOLP_VI and I counted each individual change CR_ST ST_NOLP NOLP_VI. If there were repeated change, its frequency would gt 1 as the following modified data shows.  Anyway i am not sure what boin asked for. data have; input LP_STATUS_ID $ UPDT_DT :anydtdte. CT_KEY; datalines; VI 29-Dec-14 1 NOLP 21-Jan-15 1 CR 4-Nov-14 2 NOLP 14-Dec-14 2 LP 4-Jan-14 4 NOLP 5-Jul-13 4 LP 21-Jul-14 5 CR 4-Feb-14 5 NOLP 4-Mar-14 5 VI 4-Jun-14 6 NOLP 4-Nov-14 6 CR 4-Oct-14 7 ST 4-Sep-14 7 CR 6-Oct-14 7 ST 5-Oct-14 7 NOLP 4-Aug-14 7 VI 4-Jul-14 7 ; ... View more

In my understanding  boin might want to count freq of the same route. thanks for PGStats. just got how to input dd-mmm-yy data have; input LP_STATUS_ID $ UPDT_DT :anydtdte. CT_KEY; datalines; VI 29-Dec-14 1 NOLP 21-Jan-15 1 CR 4-Nov-14 2 NOLP 14-Dec-14 2 LP 4-Jan-14 4 NOLP 5-Jul-13 4 LP 21-Jul-14 5 CR 4-Feb-14 5 NOLP 4-Mar-14 5 VI 4-Jun-14 6 NOLP 4-Nov-14 6 CR 4-Oct-14 7 ST 4-Sep-14 7 NOLP 4-Aug-14 7 VI 4-Jul-14 7 ; proc sort data=have out=have1;     by ct_key updt_dt lp_status_id; run; data have1;     set have1;     by ct_key updt_dt lp_status_id;     retain _temp;     if first.ct_key then _temp=lp_status_id;     if not first.ct_key and _temp ne lp_status_id then do;         _lp=catx('_to_',_temp,lp_status_id);         _temp=lp_status_id;     end; run; proc freq data=have1(where=(not missing(_lp))) noprint;    tables ct_key*_lp / out=have2; run; proc transpose data=have2 out=want(drop=_name_ _label_) prefix=Changed_from_;     id _lp;     var count;     by ct_key; run; ... View more