They are different.  For example, one would be 0235, the other in dataset2 should be 235, what is an option to get rid of 0 That is why I tried to substr  but as you said, substr is for character variable so can you provide a sample code, an option to remove the first zero? ... View more

I am sorry I have not made it clear.   The two exsisted datasets have their already generated code system.   The dataset1  code is 0123, 0125, 0156   correspoindingly, the dataset 2 code is 123, 125, 156   they are just same, but becuase of different versions of coding system i really just need to delete the dataset1  first zero so that I can merge, I need a multiple match merge   so the dataset 1 is a reference dataset with 100 obs, it explains all those meanings of 0123, 0125, 156  and their realted different cateogries the dataset2 is a  dataset with over 10,000 obs. then the expect merged datasets with have all those obs with different explaination i need to remove 0 from the dataset1 so that I can merge ... View more

both are numerical variables num 8   I am doing the first step. I want to create a new variable, named as icode2 icode2= substr(code1, 2,3)   database1 has code 1, it is like 0123,0231,0234 database2 has code 2, like 123, 231, 234   so I thought of substr to do this, to create a new varaible icode2, then merge it based on code2=icode2 ... View more

Thank you. But I do not get that. Can you explain in more detail? Step by step, if there are more than two steps? ... View more

Thank you. ... View more