发帖
雷达卡
---------------------------------------
Hi, I have several cross-section data which id(here named region) and year variable, I want to append them togather to form a panel. When trying to achieve this goal with --append-- command, I encouter series problem that some observations were lost for certain year(s)t, but they are not really missing observation as I can see them in the raw data. So I check the cross-section data sets seperately and find in the these certain year the value of int type variable region is different from other years (I use --recode-- code command to convert "region" from string to int) .For example,the value of region name "哈尔滨"in 5 of 6 data sets are 65 but in year2012 it's 63 so there is a inconsistency. I don't know what cause the inconsistent, the variable type is uniform for all region names and I didn't give them any (value or variable) label before appending. Using the -xtdes- command, I found about 80% of my observations are balanced with the missing of id names concentrated at two years,2012and2006,see below
Freq. Percent Cum. Pattern
---------------------------+----------
262 80.62 80.62 11111111
19 5.85 86.46 1111111.
10 3.08 89.54 1.111111
6 1.85 91.38 .1111111
5 1.54 92.92 ..111111
3 0.92 93.85 11111.11
2 0.62 94.46 ..1.111.
2 0.62 95.08 11.1...1
1 0.31 95.38 ......1.
15 4.62 100.00 (other patterns)
---------------------------+----------
325 100.00 XXXXXXXX
I highly suspect that this problem is due to some kinds of differences of id names (region in this case) between different cross-section data sets. In principle, the --encode-- command attach unique code to a id name, regardless its relative position. But even I tried to copy the id names of master datasets to substitute the corresponding ones in certain years, the problem remained.That really confuse me. Is that possible that my id names are in chinese characters (b/c they are chinese data) cause this problems ? I don't know. , but it worked just fine in the most
cases and I have too many of them so give id a english names is extremely cubersome
I have stucked by this problem for 2 days and still have no hope, I feel it may due to some stupid reasons that I cannot find. The worst thing is that I have no one to seek for help nearby. So specialists on statalist,please check it and give me some clue, Thank you in advance. Here I pose the raw data, cross-section data and my appended panel data
京公网安备 11010802022788号
