Re: st: Change variable

[Robson Glasscock <glasscockrc@vcu.edu>]

Hi Ay,

No need for an apology. This is a m:1 merge using household(id1) and
child(id2).

Sort File 1 on household and child. Save it.
Sort File 2 on household. Save it.

Go into file_1 and type:

merge m:1 household child using File_2.dta

Note that it looks to me from the data you provided that household 2
has child 4 and child 3 in File 1, but File 2 only has child 1. Also,
household 3 in File 1 has child 5, but household 3 in File 2 has child
2. These will show up as observations where _merge != 3 after you
merge the files.

best,
Robson Glasscock

On Thu, Sep 15, 2011 at 6:02 AM, Ay <yuniphone@yahoo.co.id> wrote:
> Dear Robson,
>
> My apologize about my unclear question.
>
> I try to list the variables and data in rows rather than in colomn.
>
> File 1
> Household(id1)->
> 1, 1, 1, 2, 2, 2, 3, ...
>
> Child(id2)->
> 2, 2, 3, 4, 3, 3, 5, ...
>
> Educlevel->
> 2, 1, 1, 2, 2, 1, 1, ...
>
> X3(schooltype)->
> a, b, a, b, a, a, b, ...
>
> X4(repetition)
> 2, 2, 2, 2, 2, 2, 2, ...
>
> Educlevel in strings.
> Educlevel=1 is primary school.
> Educlevel=2 is secondary level.
> A child may have secondary level and thus have records for his primary level along with other variables in file1.
>
>
> File 2
> Household(id1)->
> 1, 2, 3, ...
>
> Child(id2)->
> 3, 1, 2, ...
>
> X3(ethnicity)
> 1, 3, 2,  ...
>
> X4(livings)->
> 1, 2, 2,  ...
>
> In file 2 only single obs.
>
> I hope this is clearer.
>
> Thank you.
>
> Regards,
>
> Yun
>
>
> On 11 Sep 2011, at 01:53, Robson Glasscock <glasscockrc@vcu.edu> wrote:
>
>> So File 1 is a panel data set that records each individual's
>> educational level over time? If that is the case, and if File 2 is
>> also panel data, then a 1:1 merge based on x1(unique id) and x3(time
>> period) could be done.
>>
>> If File 2 is not panel data, then you're looking at a m:1 merge based
>> on x1(unique id).
>>
>> If this doesn't solve the problem, I think you should include an
>> example of the observations in each of your files on your next post.
>> I'm still struggling a bit to picture the contents of your files.
>>
>> On Sat, Sep 10, 2011 at 9:20 AM, Ay <yuniphone@yahoo.co.id> wrote:
>>> Dear Robson,
>>>
>>> Thank you for replying.
>>>
>>> Actually,
>>> File 1:
>>> x1 (unique id)
>>> x2 (educational level)
>>>
>>> File 2
>>> x1 (unique id)
>>>
>>>
>>> In file 2, x1 & x2 together are unique id. All of the variables are in strings.
>>>
>>> I could not merge file1 and file 2 since x2 is the educational level in which an individual would have more than 1 level/type.
>>>
>>> Thank you,
>>>
>>> Yun
>>>
>>>
>>>
>>>
>>>
>>>
>>> On 10 Sep 2011, at 22:56, Robson Glasscock <glasscockrc@vcu.edu> wrote:
>>>
>>>> I'm having a hard time understanding the structure of your "first
>>>> file" and your "second file. Do your files looks like this:
>>>>
>>>> File 1:
>>>> x1
>>>> (unique id + educational level)
>>>>
>>>> File 2:
>>>> x1
>>>> (unique id)
>>>>
>>>> so that File 1 contains a concatenated variable?
>>>>
>>>> If File 1 has one variable, x1, that is concatenated, then I don't
>>>> think you need to merge the files together to get what you want. You
>>>> would just need to split x1(unique id + educational level) into
>>>> x1(unique id) and x2(educational level). The substr function may be
>>>> used to do this.
>>>>
>>>> -help substr-
>>>>
>>>> best,
>>>> Robson Glasscock
>>>>
>>>> On Fri, Sep 9, 2011 at 5:27 PM, Ay <yuniphone@yahoo.co.id> wrote:
>>>>>
>>>>> I am using stata 11.0
>>>>>
>>>>> How can i generate or change a variable that contains for instance, educational level or father and mother as 'Type'?
>>>>> The variables are in strings format.
>>>>>
>>>>> The reason i am asking this question is that, i want to merge these 'type' variable (var B) with other variable.
>>>>> I could not do this since the second file only has variable A as individual id variable. While in the first file, it has var A and var B ('type' or level variable) as unique Id.
>>>>>
>>>>> If anyone knows other ways besides generating the type variable before merging, I really appreciate it.
>>>>>
>>>>> Variable a
>>>>> 1,2,1,1,2,3,3
>>>>>
>>>>> Variable b(type)
>>>>> A,A,B,C,B,C,A
>>>>>
>>>>> Many thanks.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Yun
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *
>>>>> *   For searches and help try:
>>>>> *   http://www.stata.com/help.cgi?search
>>>>> *   http://www.stata.com/support/statalist/faq
>>>>> *   http://www.ats.ucla.edu/stat/stata/
>>>>
>>>> *
>>>> *   For searches and help try:
>>>> *   http://www.stata.com/help.cgi?search
>>>> *   http://www.stata.com/support/statalist/faq
>>>> *   http://www.ats.ucla.edu/stat/stata/
>>>
>>> *
>>> *   For searches and help try:
>>> *   http://www.stata.com/help.cgi?search
>>> *   http://www.stata.com/support/statalist/faq
>>> *   http://www.ats.ucla.edu/stat/stata/
>>>
>>
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/statalist/faq
>> *   http://www.ats.ucla.edu/stat/stata/
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

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