Hi everyone,
I want to set up data for nested logit model. My current data is as indicated below. The firms (tax_code) choose to locate their plants in a province (province_code). In order to run nested logit model, I know I need to have two variables: one variable is "alternative" which lists all the province codes in the dataset and one variable "chosen" which receives the value 1 if the province is chosen and 0 otherwise (depending on the variable "province_code").
1. Would you mind helping me to set up the data? I know the data should be in long form and read similar posts, but I could not figure out.
2. Is there any limitation in the number of independent variables I should choose for nested logit model? My actual data set has 56 more variables (due to the model I am experimenting with). I know this is too many variables.
Thank you so much! Really look forward to your help.
[/CODE]
I want to set up data for nested logit model. My current data is as indicated below. The firms (tax_code) choose to locate their plants in a province (province_code). In order to run nested logit model, I know I need to have two variables: one variable is "alternative" which lists all the province codes in the dataset and one variable "chosen" which receives the value 1 if the province is chosen and 0 otherwise (depending on the variable "province_code").
1. Would you mind helping me to set up the data? I know the data should be in long form and read similar posts, but I could not figure out.
2. Is there any limitation in the number of independent variables I should choose for nested logit model? My actual data set has 56 more variables (due to the model I am experimenting with). I know this is too many variables.
Thank you so much! Really look forward to your help.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str10 tax_code str4 sector4d str2 sector2d str4 technology str2 province_code double PCI byte(govpo Intel) double openness byte habour double(road labour) "0108401046" "1622" "16" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108058196" "1410" "14" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108211944" "3312" "33" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0101744855" "2599" "25" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108385570" "3312" "33" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108133735" "2610" "26" "High" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0107952393" "3030" "30" "High" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0107997813" "2610" "26" "High" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108167389" "3312" "33" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108102769" "2630" "26" "High" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0315131172" "1312" "13" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108058654" "2511" "25" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108371994" "3320" "33" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108398989" "2610" "26" "High" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108194008" "2740" "27" "High" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108340682" "1050" "10" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "0108254666" "3320" "33" "Low" "01" 64.71 1 1 78.42528505940291 0 7332.2 44.2 "4700269589" "1030" "10" "Low" "06" 58.82 0 0 .4098470613650569 0 30.5 17.2 "2300896937" "2630" "26" "High" "19" 64.45 0 1 47.85489957755328 0 943.8 26 "4601515138" "2399" "23" "Low" "19" 64.45 0 1 47.85489957755328 0 943.8 26 "4601190592" "2750" "27" "High" "19" 64.45 0 1 47.85489957755328 0 943.8 26 "4601505179" "2630" "26" "High" "19" 64.45 0 1 47.85489957755328 0 943.8 26 "4601503439" "2630" "26" "High" "19" 64.45 0 1 47.85489957755328 0 943.8 26 "4601499831" "3313" "33" "Low" "19" 64.45 0 1 47.85489957755328 0 943.8 26 "5701821116" "3230" "32" "Low" "22" 70.69 1 0 768.5431210367329 1 786.3 32.9 "5701820634" "1312" "13" "Low" "22" 70.69 1 0 768.5431210367329 1 786.3 32.9 "2400837357" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400843696" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400831570" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400830418" "1420" "14" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400843713" "2029" "20" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400823403" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400835335" "2022" "20" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400850460" "2420" "24" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400830506" "3313" "33" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400848091" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400821364" "2822" "28" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400847041" "2220" "22" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400825802" "2651" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400822664" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400825217" "1621" "16" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400838819" "2610" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400830792" "2511" "25" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400827623" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400825312" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400822713" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400824485" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400832327" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400827422" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400842283" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400830030" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400841716" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400842861" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400838093" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400831644" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400813839" "2599" "25" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400833578" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400831637" "2220" "22" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400832976" "2630" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400833916" "2610" "26" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400833514" "2710" "27" "High" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2400832567" "2592" "25" "Low" "24" 62.2 0 0 77.68405514135863 0 611 17.9 "2600974946" "2220" "22" "Low" "25" 62.55 0 0 48.67541465211306 0 608.6 21.8 "2600978997" "2610" "26" "High" "25" 62.55 0 0 48.67541465211306 0 608.6 21.8 "2600981855" "2731" "27" "High" "25" 62.55 0 0 48.67541465211306 0 608.6 21.8 "2600982947" "2220" "22" "Low" "25" 62.55 0 0 48.67541465211306 0 608.6 21.8 "2600993089" "1621" "16" "Low" "25" 62.55 0 0 48.67541465211306 0 608.6 21.8 "2600958687" "1410" "14" "Low" "25" 62.55 0 0 48.67541465211306 0 608.6 21.8 "2500614178" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500604003" "3091" "30" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500598568" "3091" "30" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500598198" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500612981" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500598416" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500604324" "2592" "25" "Low" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500592164" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500612621" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500601588" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500596909" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2300614212" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500598286" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500597483" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500594080" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500593866" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500600312" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500597525" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500593506" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500606385" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500599434" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500614354" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500602214" "2220" "22" "Low" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500596225" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500616739" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2500600471" "2610" "26" "High" "26" 64.9 1 0 190.45607418097808 0 843.7 22.1 "2300997163" "2220" "22" "Low" "27" 64.36 1 0 105.16843459715358 0 616.9 22.4 "2300997195" "2750" "27" "High" "27" 64.36 1 0 105.16843459715358 0 616.9 22.4 "2301021913" "1410" "14" "Low" "27" 64.36 1 0 105.16843459715358 0 616.9 22.4 "2301019671" "2630" "26" "High" "27" 64.36 1 0 105.16843459715358 0 616.9 22.4 "2301037769" "2599" "25" "Low" "27" 64.36 1 0 105.16843459715358 0 616.9 22.4 "2301000021" "2220" "22" "Low" "27" 64.36 1 0 105.16843459715358 0 616.9 22.4 end
[/CODE]
