Dear all, Assume there are two datasets as follow: data one; input A B; cards; 4 6 3 2 run; data two; input C D; cards; 1 3 2 5 3 8 4 7 run; As you see neither variables nor obs are equal. I would like to create another variable E in dataset one which is equal to var D where A=C. Finally, I am looking for a dataset for example like this: A B C D E 4 6 . . 7 3 2 . . 8 . . 1 3 . . . 2 5 . . . 3 8 . . . 4 7 . So I can do some analyses on A and E. Please let me know if I can use SAS for this reason. Thank you!
... View more