Hello, I have the following table CUST: Panid Age Buy 1 45 2 50 3 70 4 80 5 33 6 20 The Buy column is empty. I would like to update it to values 0 or 1 based on if Panid exists in another table BUYFR: Panid Category 3 Frozen food 5 Frozen food 6 Frozen food The code should update variable Buy corresponding to variable Panid 3,5 and 6 to 1. Rest all Should be zero. The Final output should look similar to : Panid Age Buy 1 45 0 2 50 0 3 70 1 4 80 0 5 33 1 6 20 1 Please let me know how this can be implemented in SAS?
... View more