Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Change variable


From   Ay <yuniphone@yahoo.co.id>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Change variable
Date   Sat, 10 Sep 2011 23:20:04 +1000

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index