creating new variable based on some observations of another variable

[Hossein Jebeli]

Hi,

Attached file is a data of international trade, but the "country" variable has the name of countries for each industry classification (Naics codes). How can I make a new variable, like Naics, which shows the 4-digit Naics codes shown in some observations of the "country" variable (like observations 1 and 126 and...)?

Thanks,

Hossein

[Hossein Jebeli]

If data can't be opened, it is something like this:

country ------------value
naics 3111----------- .
US --------------684661842
Denmark-------37939608
naics 3112--------- .
Denmark ----- 4354562

I want to make a dataset which is like:

country ----------value ---------- naics
US ---------- 684661842 ----- 3111
Denmark --- 37939608 ------ 3111
Denmark -----4354562 ------- 3112

Hossein

[Robert Picard]

Please follow the advice in the FAQ and present data examples using dataex (from SSC). To install it, type in Stata's Command window:

ssc install dataex

[Hossein Jebeli]

Thans Robert! Here is an example of the data:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str104 country double value
"NAICS 3111 - Animal Food Manufacturing"         .
"United States"                          684661842
"Russia"                                  37939608
"Japan"                                   37479174
"Mexico"                                  28458726
"Hong Kong"                               20846344
"Korea, South"                            19720998
"Philippines"                             19511516
"France (incl. Monaco, French Antilles)"  17957398
"Spain"                                   17393224
"New Zealand"                             15058969
"Brazil"                                  14563508
"Taiwan"                                  13920641
"China"                                   12057257
"Sweden"                                  10328655
"Germany"                                 10138460
"United Kingdom"                           9967849
"Poland"                                   9845098
"Vietnam"                                  8951077
"Italy (incl. Vatican City State)"         8806257
"Israel"                                   8419413
"Czech Republic"                           7323256
"Belgium"                                  5354957
"Netherlands"                              5165249
"Australia"                                4811477
"Singapore"                                4751949
"South Africa"                             4446334
"Turkey"                                   4419906
"Norway"                                   3878708
"Ukraine"                                  3423367
"Denmark"                                  2993468
"Malaysia"                                 2966407
"Myanmar (Burma)"                          2949252
"Greece"                                   2706872
"Peru"                                     2666758
"Finland"                                  2242319
"Colombia"                                 2121787
"Thailand"                                 1924293
"Egypt"                                    1871189
"Portugal"                                 1546995
"Hungary"                                  1531679
"Romania"                                  1411736
"Switzerland"                              1273357
"Uruguay"                                  1216107
"Slovakia"                                 1164316
"Chile"                                    1103202
"Latvia"                                    963147
"Cyprus"                                    937071
"Algeria"                                   920399
"Indonesia"                                 904318
"Lithuania"                                 748808
"India"                                     742681
"United Arab Emirates"                      728315
"Dominican Republic"                        689382
"Bangladesh"                                653538
"Jamaica"                                   653458
"Nigeria"                                   573729
"Pakistan"                                  532270
"Costa Rica"                                482127
"Saudi Arabia"                              466938
"Estonia"                                   442299
"Croatia"                                   439289
"Bulgaria"                                  405345
"Kuwait"                                    381612
"Jordan"                                    344071
"Argentina"                                 331001
"Venezuela"                                 326644
"Saint Pierre-Miquelon"                     305506
"Tunisia"                                   236988
"Trinidad and Tobago"                       225918
"Morocco"                                   201082
"Malta"                                     200773
"Ecuador"                                   178198
"Panama"                                    152113
"Slovenia"                                  139670
"Greenland"                                 133510
"Saint Vincent and the Grenadines"           99832
"Swaziland"                                  91967
"El Salvador"                                91598
"Guatemala"                                  88235
"Ghana"                                      78676
"Curacao"                                    75384
"Sri Lanka"                                  62374
"Aruba"                                      62240
"Macau (Macao)"                              41312
"Barbados"                                   38116
"Mali"                                       38000
"Senegal"                                    32250
"Madagascar"                                 28838
"Nepal"                                      23060
"U.S. Minor Outlying Islands"                21675
"Iran"                                       18401
"Antigua and Barbuda"                        17923
"Qatar"                                      15753
"Benin"                                      10300
"Guyana"                                      9599
"Cayman Islands"                              8136
"Dominica"                                    4189
"Lebanon"                                     1747
"Cuba"                                           .
end