A. I have this data (short) with 50 date variables DFS_Fam1 - DFS_Fam50. Some observations do not have date value for DFS_Fam1 - DFS_Fam50 I want to create variables that show if a date value is available, it is indicated as 1, and no date value = 0 or missing. ID DFS_Fam1 DFS_Fam2 DFS_Fam3 1 01/01/2023 02/01/2023 03/01/2023 2 04/01/2023 05/01/2023 06/01/2023 3 05/01/2023 For example for observation 1, if DFS_Fam1, DFS_Fam2, DFS_Fam3 have date values, then New_A1=1, New_A2=1, New_A3=1 as shown (but up to whenever DFS_Fam has dates) ID DFS_Fam1 DFS_Fam2 DFS_Fam3 New_A1 New_A2 New_A3 1 01/01/2023 02/01/2023 03/01/2023 1 1 1 2 04/01/2023 05/01/2023 06/01/2023 1 1 1 3 05/01/2023 1 This is clinical data, everyone has DFS_Fam1 but not necessary DFS_Fam2 , DFS_Fam3 up to DFS_Fam50, thus there would be missing dates. How do I go about these without writing 50 lines of code? B. I would like to convert New_A to time points Data long; set short; New=New_A1; time=0; output; New=New_A2; time=1; output; New=New_A3; time=2; output; ... .... ......... ....... New=New_A50; time=50; output; How do I go about these without writing 50 lines of code? Thanks.
... View more