Re: st: Change variable

[Ay <yuniphone@yahoo.co.id>]

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/