Hi all I would like to create a new variable based on another column in sas visual analytics. I have this dataformat: ItemID ItemID_reference My wanted output 1111 . 0 2222 8888 0 3333 . 0 4444 1111 1 5555 . 0 6666 7777 1 7777 . 0 How can I match the value from ItemID_reference to the values of ItemID? In other words: If a value of ItemID_reference is any of ItemID, return 1 else 0. Thanks!
... View more