| Re: How to transform children's height into standardized height [message #3793 is a reply to message #3786] |
Wed, 11 February 2015 13:58   |
Reduced-For(u)m
Messages: 292
Registered: March 2013
|
Senior Member |
|
|
Interesting - without knowing why you'd want to do that, let me offer a suggestion:
Generate some fake data on a bunch of observations (N), all with age of 48 and gender female. Then, for each observation, give them a height "70, 70.1, 70.2... 96.7, 96.8" etc.
Now, use zscore06 to calculate the HAZ for each of these fake observations (maybe to 1 decimal place or something). Now you have a dataset that links HAZ with girls height at age 48 months. With the output from that, you could write a little program that takes the z-scores you calculated for your real children and gives you height for girl at age 48 months. One way would be to export your fake data into Excel, and use the "stupid excel trick" to write code (essentially: write columns with "replace RawHieghtGirl48 = $c1" and "if HAZreal==$d1" - and use the concatenate command).
Then paste that code into a Stata .do file, and use it to convert the real HAZ into the height of a 48 month old girl (so you'd have N lines of code, one for each value of HAZ, all looking almost exactly the same but referring to different real HAZ values). Then just run the do file and get, for each person, what their raw height would be if they had that HAZ and were 48 month old girls.
If this is helpful, in exchange you can explain to me the value of making everyone comparably-heighted to a 4 year old girl (it must be buying you some kind of comparison you want...)
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
