Hello, I have a dataset where I am trying to fill in the date value using values in another column . The condition I am trying to apply is for each ID, if any one row is blank then leave blank. Fill in date value if all rows has date. Can you please help with the sas code. Here is the variable attribute and table I have and want. There are other variables as well in the actual dataset. Variable Type Len Format Informat ID Num 8 BEST. End Date Num 8 MMDDYY10. MMDDYY10. Problem 3 Data: Have3 Data: Want3 ID End Date ID End Date End Date1 1 1 1 12/24/2023 1 12/24/2023 1 1 12/24/2023 1 12/24/2023 2 1/13/2005 2 1/13/2005 2 1/13/2005 2 1/13/2005 2 2 3 3 3 3/5/2017 3 3/5/2017 3 3 3 3 3 3 4 4 4 4 4 4 5 5/5/2020 5 5/5/2020 5/5/2020 5 5/5/2020 5 5/5/2020 5/5/2020 6 11/1/2024 6 11/1/2024 11/1/2024 Thank you.
... View more