Hello everyone,

I've the following data which is referenced by it's id variable. For each ID, it has city and statefip name.

Is there any easier way to convert it to USA countyfip code like census county code from the existing information of my data. Some of the data has information about international city which doesn't provide any statefip information.


Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str14 id strL city str3 statefip
"04840815" "POMONA"          "CA"
"05434252" "GLENVIEW"        "IL"
"05434252" "EVANSTON"        "IL"
"05603052" "NEW YORK"        "NY"
"05823902" "BUCYRUS"         "OH"
"05823902" "BUCYRUS"         "OH"
"06332032" "ITHACA"          "NY"
"06332032" "ITHACA"          "NY"
"06490502" "CROYDON"         "NH"
"06490502" "STRATFORD"       "CT"
"08211955" ""                ""  
"08379649" ""                ""  
"07965267" ""                ""  
"08392957" ""                ""  
"08564130" ""                ""  
"08464759" ""                ""  
"08433467" ""                ""  
"07098353" "WUPPERTAL"       ""  
"07098353" "KOELN"           ""  
"08522419" ""                ""  
"09092710" "CATANIA"         ""  
"09092710" "PALERMO"         ""
"08762555" "SINGAPORE"       ""  
"08762555" "SINGAPORE"       ""  
end