just merge the first with the second on HS(SUB)
On Thu, 29 Jan 2004, Delis, A. wrote:
> Dear Statalisters
>
>
> I have a concordance that maps two classification codes (numerical values)
>
> HS SIC87
>
> 1001.10.0000 01110
> 1001.10.0010 01110
> 1001.10.0090 01110
> 1006.10.0000 01120
> 1005.10.0000 01150
> 1005.90.2000 01150
> 1005.90.4060 01150
> 1201.00.0020 01160
> 0708.20.2000 01190
> 0708.90.0000 01190
> 1207.20.0000 01313
> 1207.20.0090 01313
> 5201.00.1010 01313
> 1209.11.0000 01330
> 1212.91.0000 01330
> 1212.92.0000 01330
> 0701.10.0000 01340
> 0701.10.0020 01340
>
> I also have two series the first, HSSUB, is a subset of HS and the second, X, that gives the value of a variable for the
> corresponding HS classification.
>
> HSSUB X
>
> 1001.10.0000 500
> 1005.10.0000 1500
> 1201.00.0020 3254
> 1207.20.0000 1245
> 1212.91.0000 8261
> 1212.92.0000 2483
> 0701.10.0000 12354
> 0701.10.0020 12480
>
> What I want to do is to create a new variable that gives the corresponding SIC87 classification
> from the above concordance, ie
>
> HSSUB VALUE SIC87
>
> 1001.10.0000 500 01110
> 1005.10.0000 1500 01150
> 1201.00.0020 3254 01160
> 1207.20.0000 1245 01313
> 1212.91.0000 8261 01330
> 1212.92.0000 2483 01330
> 0701.10.0000 12354 01340
> 0701.10.0020 12480 01340
>
>
>
> Thank you in advance
>
> Agelos Delis
>
> *
> * 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/
>
--
Edwin Leuven
Department of Economics
University of Amsterdam
Roetersstraat 11
1018 WB Amsterdam
the Netherlands
tel: +31 20 525 5241
fax: +31 20 525 4310
http://www.fee.uva.nl/scholar/mdw/leuven
*
* 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/
