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/
