Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Merging files


From   me <enchantee_76@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Merging files
Date   Wed, 16 Feb 2005 16:56:12 -0800 (PST)

Hi Rafal,

Somewhat...respondent id is a unique identifier for
each respondent.  However, respondent #'s 2 and 3 may
have an identical zip.  I would want to make sure that
nocomp for each of those would be equal (reflecting
the zip code attached).  

Thanks!
--- Rafal Raciborski <rafal.raciborski@emory.edu>
wrote:

> Hi Dari,
> Is this what you want to accomplish?
> rafal
> 
> 
> . use C:\temp\using.dta
> . list
> 
>      +----------------+
>      |   zip   no_org |
>      |----------------|
>   1. | 12345       23 |
>   2. | 23456       41 |
>   3. | 34567       19 |
>   4. | 56789       56 |
>      +----------------+
> 
> . sort zip
> . save, replace
> 
> . use C:\temp\master.dta, clear
> . list
> 
>      +----------------+
>      | resp_id    zip |
>      |----------------|
>   1. |      1   12345 |
>   2. |      1   23456 |
>   3. |      1   34567 |
>   4. |      2   12345 |
>   5. |      3   23456 |
>      |----------------|
>   6. |      3   56789 |
>      +----------------+
> 
> . sort zip
> 
> . merge zip using C:\temp\using.dta
> . sort resp_id zip
> . list
> 
>      +----------------------------------+
>      | respid     zip   nocomp   _merge |
>      |----------------------------------|
>   1. |      1   12345       23        3 |
>   2. |      1   23456       41        3 |
>   3. |      1   34567       19        3 |
>   4. |      2   12345       23        3 |
>   5. |      3   23456       41        3 |
>      |----------------------------------|
>   6. |      3   56789       56        3 |
>      +----------------------------------+
> 
> . drop _merge
> 
> 
> ================
> Rafal Raciborski
> Graduate student
> Department of Political Science
> Emory University
> 301 Tarbutton Hall
> 1555 Dickey Drive
> Atlanta, GA 30322
> 404-378-9826 (home)
> rafal.raciborski@emory.edu (e-mail)
> www.roofoos.net
> 
> *
> *   For searches and help try:
> *  
> http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
> 


=====
"Can't break now I've been living for this 
Won't break now I'm cleansed with hopefulness."


	
		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index