Hello, Could anyone help me on how to update observations in an existing SAS dataset, using another dataset. Like, I have 2 datasets :- DATA Data_one; input id prod $ v1 v2 v3 v4 v5; datalines; 100 abc 1 0 0 0 0 102 asd 1 1 0 0 0 105 0 1 0 0 0 100 pqr 1 0 0 0 0 102 sdf 0 1 0 0 0 103 rty 1 1 0 0 0 ; run; DATA Data_two; input id v3 v4 v5; datalines; 100 1 0 1 102 0 1 0 103 0 0 0 105 1 0 0 ; run; I want the fields v3,v4,v5 of Data_one to be updated according to Data_two on the basis of the ID field. I tried using merge statement, but that updated only the first observation for each group. For ex. in Data_one, I want for ID 100 the fields should get updated as 1,0,1 under 'abc' as well as under 'pqr', and not only under 'abc'. Please help. Thank you in advance!
... View more