I sample input data looks like below after sorting for a SAS data set. Id date status 9212 12/01/2021 LC 9212 03/01/2022 LC 9212 05/01/2022 LC 9212 06/01/2022 CC 6083 12/01/2023 LC 8228 12/012023 LC 8228 03/01/2022 LC 8228 06/01/2022 CC 7756 02/01/2023 FC 7756 06/01/2023 FC 7756 07 /01/2023 FC Want to have out put as below. 12/01/9999 is a default date. Id status In_date out_date 9212 LC 12/01/2021 06/01/2022 9212 CC 06/01/2022 12/01/9999 6083 LC 12/01/2023 12/01/9999 8228 LC 12/012023 06/01/2022 8228 CC 06/01/2022 12/01/9999 7756 FC 02/01/2023 12/01/9999 Please help to code in data SAS script. Thanks in advance for the help.
... View more