Hi , How to transpose below data set to the desired data set. actual data set: NO DATE_EFFCT CLASS PLAN KEY 1 20210817 ARP 1 XXX001 2 20210817 ARP 1 XXX001 1 20201012 SSP 2 XXX002 2 20201013 SSP 2 XXX002 desired data set: KEY DATE_EFFCT NO_1 CLASS_1 PLAN_1 NO_2 CLASS_2 PLAN_2 XXX001 20210817 1 ARP 1 2 ARP 1 XXX002 20201012 1 SSP 2 XXX002 20201013 2 SSP 2 and if there are 3 Nos then NO_3 CLASS_3 PLAN_3 should automatically be created. The group variables should be KEY and DATE_EFFCT. Request help on this. Thanks, Swathi
... View more