Hi all, I have a problem how to proceed in sas for the conversion of two dataset in one, based on a reference dataset. These is my problem in simple words: "Reference data" G1 G2 var1 A B var2 C D var3 E F Letters in variable G1 are equivalent to '1' and variable G2 are equivalent to '0'. But are not the same letter for all var1--3 "Real data" var1 var2 var3 ID1 AA CD FE ID2 BA CC . ID3 BB . FF ID4 AB CD EF I have a combination of G1 and G2, and also missing values... What I want: var1 var2 var3 ID1 2 1 1 ID2 1 2 . ID3 0 . 0 ID4 1 1 1 I was thinking in counting letter one based on G1 of my reference dataset.. but I'm not sure about it. I must to confess that I'm lost in how to solved it. Is very simple what I want, but I'm pretty sure that the solution is not so simple. Thanks a lot
... View more