Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | R Zhang <r05zhang@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | st: Identify observations that appear in a list |
| Date | Wed, 12 Mar 2014 22:12:35 -0400 |
Dear Statalisters, I have the following data set (HAVE) (only provide a few observations as illustration). The input variable gives the dollar input sold by supplier to customer. You will notice that customer industry 4000B, 3000A also appear in SupplierIndustry. This indicates that some industries can be both suppliers and customer. +++++++++++++++++++++++ HAVE CustomerIndustry SupplierIndustry Input 1000A 4000B 100 1000A 3000A 200 1000A 3000B 100 1000B 4000B 50 1000B 2000A 8 4000B 3000A 19 4000B 2000A 20 3000A 3000B 18 3000A 3000D 12 2000A 1000D 25 +++++++++++++++++++++++ I want to create a dataset that list all customer industries that are also supplier industry, i.e., my output shall appear as : CustomerIndustry SupplierIndustry Input 4000B 3000A 19 4000B 2000A 20 3000A 3000B 18 3000A 3000D 12 2000A 1000D 25 I am asking for your help on coding this. Thanks!!! * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/