I've never done a proc tranpose and cannot get the desired result after reading the documentation I have a dataset that looks like this Acct1 AcctLevel State Last_State_Date 1 A OH 05-23-2023 1 A MI 11-30-2023 2 C TX 01-22-2023 2 C CA 04-14-2023 2 C MO 07-25-2023 3 F OH 06-22-2023 3 F IN 12-12-2023 3 K WA 08-01-2023 And the desired output is: Acct AcctLevel State1 Date1 State2 Date2 State3 Date 3 1 A OH 05-23-2023 MI 11-30-2023 2 C TX 01-22-2023 CA 04-14-2023 MO 07-25-2023 3 F OH 06-22-2023 IN 12-12-2023 3 K WA 08-01-2023 Please help
... View more