Re: st: Change variable

[Robson Glasscock <glasscockrc@vcu.edu>]

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/