I've posted what I have and what I want in a table below. Here's the code I'm currently using. Wondering if there is a way to only print the vaccine_x variable on the first line of the id. Then I plan to only keep first.id. I can create new variables if needed. Thanks in advance. Current code:  data want; set have; format vaccine_1 vaccine_2 vaccine_3 vaccine_4 vaccine_5 mmddyy10.; if vaccine_sequence=1 then vaccine_1 = vaccine_admin_date; else vaccine_1=.; if vaccine_sequence=2 then vaccine_2 = vaccine_admin_date; else vaccine_2=.; if vaccine_sequence=3 then vaccine_3 = vaccine_admin_date; else vaccine_3=.; if vaccine_sequence=4 then vaccine_4 = vaccine_admin_date; else vaccine_4=.; if vaccine_sequence=5 then vaccine_5 = vaccine_admin_date; else vaccine_5=.; proc print; HAVE             id vaccine_admin_date vaccine_sequence vaccine_1 vaccine_2 vaccine_3 vaccine_4 1 7/1/2024 1 7/1/2024       1 8/1/2024 2   8/1/2024     1 9/1/2024 3     9/1/2024   1 10/1/2024 4       10/1/2024 2 1/2/2024 1 1/2/2024       2 2/2/2024 2   2/2/2024     2 3/2/2024 3     3/2/2024   2 4/2/2024 4       4/2/2024               WANT             id vaccine_admin_date vaccine_sequence vaccine_1 vaccine_2 vaccine_3 vaccine_4 1 7/1/2024 1 7/1/2024 8/1/2024 9/1/2024 10/1/2024 1 8/1/2024 2         1 9/1/2024 3         1 10/1/2024 4         2 1/2/2024 1 1/2/2024 2/2/2024 3/2/2024 4/2/2024 2 2/2/2024 2         2 3/2/2024 3         2 4/2/2024 4         ... View more