Hi guys, I have another #SASBeginners question. Well, maybe it's not a beginner's questions, but it's a question a beginner is having trouble answering. I'm trying to update my original_dataset with data from another dataset ('data_to_add'), however I need to look at a flag and a numeric variable in the secondary dataset, to decide what variable to affect in the original_dataset. In the contrived example below, the original_dataset has all PERSON_IDs and all variables initialised to null. In the data_to_add, we have numerous instances of each PERSON_ID, with an associated column number for each ob, however only one of those obs associated for that PERSON_ID has the KEEP_BL flag set to 'Y'. So each PERSON_ID in the data_to_add has only one 'Y'. In one instance, P0004, there is no flag set at all. In this contrived example, I've used five columns, but could someone please show me how to do this for N columns? Thank you! Ta, JOE original_dataset PERSON_ID COL01_ID COL02_ID COL03_ID COL04_ID COL05_ID P0001 . . . . . P0002 . . . . . P0003 . . . . . P0004 . . . . . data_to_add PERSON_ID COL_NO KEEP_BL P0001 1 . P0001 2 Y P0001 2 . P0001 4 . P0002 5 . P0002 3 Y P0004 1 . P0004 4 . P0003 5 . P0005 1 Y P0003 1 Y Desired_dataset: PERSON_ID COL1_ID COL2_ID COL3_ID COL4_ID COL5_ID P0001 . Y . . . P0002 . . Y . . P0003 Y . . . . P0004 . . . . .
... View more