Re: st: Re: Problem with combining sibling data

[daniel klein <klein.daniel.81@gmail.com>]

Sounds to me like you just want to add up those variables.

mvdecode <yourvars> ,mv(-1 = .a \ -2 = . b)
g byte foo = <yourvar1> + <yourvar2> + ... + <yourvar4>

where foo is the variable holding the total number of siblings and
<yourvar> is to be replaced with the names of your variables.

Note that all the commands you listed are more or less commands to
analyse the dataset. That is not what you want to do.

Best
Daniel

--
>>> Hi,
>>>
>>> I am keen to try and create a total sibling variable for data that I have that is currently separated out into four vars:
>>> no.of brother-sister in same house older,
>>> no.of brother-sister in same house younger
>>> no.of brother-sister outside house older
>>> no.of brother-sister outside house younger
>>
>>> for each 0-4 = number siblings and -1 is missing questionnaire and -2 is not stated
>>>
>>> This is from a longitudinal cohort study and I'm being dense but can't seem to create a variable that gives me the sibling shape of each cohort member - I have used sum, count, total but they're not an accurate portrayal of the siblings that each cohort member has.
>>>
>>> What can you recommend?

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/