Hi thanks looks complicated on the last bits... i will try it out when back in office... What if my dataset is like below instead? Any simpler proc sql i can utilize? Set A: ID Ab1234 Bc1234 Fd2244 Set B: Column A (named as "INFO") distance, 220km ab1234 tune distance= Bc1234 322km tunez 358kmFd2244 distance tone Column B (named as "VALUE") 2000 3000 3500 I juz want to put the value from Set B onto Set A but have to look for the unique Set A ID from the swamped or jumbled Set B. Is proc sql possible or easier? Got 10 of thousands of variables under both sets. Normally i had the same unique set a and unique set b ID data to map with but this new Set b is different. For the same unique data i juz use proc sql as follows: (For same unique id) Proc sql; create table set_c as select ID, VALUE From set_a left join set_b On a.id=b.info;run; Since this new Set B is jumbled, is it possible to just use "on a.id like b.%info%" ?? Or "in" function? Wonder if that will work for proc sql?
... View more