Combine the three data sets

[JingPynn]

Hello, I need to merge the files together based on the 3 data sets. By using sex, age and weight information in the fitness file, match the body fat observations using age and weight, and match the diabetes observations using gender and age.

What I have done is renamed the variables and merged them together, and converted the lbs to kg. However there is some problem that I encountered, all the weight variable does not match(in kg) so it could not merge together and the gender in diabetes file and fitness file does not match as well.

Is it normal that all of the observations for weight are not match? Is it possible to merge the 3 files together? How can I solve the problem?Currently, Im doing it with proc sort, merge, I need some advices. Any and all help and advice would be appreciated,

[WarrenKuhfeld · Accepted solution]

Perhaps you need to round your weights to the nearest kg?

weight = round( ...computation ...);