Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Combine the three data sets

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Combine the three data sets

 

 

Fitness.pngdiabetes.pngbodyfat.png

 

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,


Accepted Solutions
Solution
‎06-25-2017 04:52 AM
SAS Employee
Posts: 118

Re: Combine the three data sets

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

 

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

View solution in original post


All Replies
Solution
‎06-25-2017 04:52 AM
SAS Employee
Posts: 118

Re: Combine the three data sets

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

 

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 175 views
  • 0 likes
  • 2 in conversation