p32c10-13 isn't there in 2000 data
p31c15 p31c16 not present in 2000
no of shifts, days per month...quesitons are for all three type of workers category in the 2002/2003 data set but in the 2004 data set it was only for the production workers check
p31c15 p31c16 not present in 20000
p32c10 p32c11 p32c12 and p32c13 not present in 2000
Mule & Arne (2008) In 2005 CSA started sampling rather than taking a census for some industries, for example bakery products. The number of bakeries (in the food industry) therefore, declined in the data in 2005. As a matter consistency, and since bakeries export very little, we excluded them in all years from the remaining analysis, which was thus based on 2250 firm/year observations.
p63c9 is dividend payment in 2000
slry variables are years 2005 and 2006
ages and school varaibles are for 1996 data only
rawno10 is only from 2005 onwards
invno1-5, avgcost_RM- avgcost_CGS, endyrcost_RM- endyrcost_CGS, withinyrcost_RM- withinyrcost_CGS are from 2005
p62c7_1- p62c7_7, p62c8_1- p62c8_7, p62c9_1- p62c9_7, p62c10_1- p62c10_7, p62c11_1- p62c11_7, p62c12_1- p62c12_7
p62c7_1- p62c7_7, p62c8_1- p62c8_7, p62c9_1- p62c9_7, p62c10_1- p62c10_7, p62c11_1- p62c11_7, p62c12_1- p62c12_7, p62c13_7 p62c14s7 are from 2005
WTC RATE from 2005
goods bought for resale is not there in 2000 data
crntK_meth- crntK_tot is not asked in 1996,1997,1998,1999,2000,and 2001
mkt_time1, mkt_time2, mkt_time3 and sell_whr are only for year 1996 data GC
p2q13 source of non-residenial bulildings is not asked for the 1996 data set. so I have to combine p2q12 p2q13 responses. see the 1997 data questionaire
so i made p2q12 to be compatible to the quesion asked as 1996GC questionaire
I dropped p31c15_1 p31c15_2 p31c15_3 p31c15_4 p31c15_5 p31c15t
I dropped p31c16_1 p31c16_2 p31c16_3 p31c16_4 p31c16_5 added them in p31c16 when they appear which was very limited case. besides only 1997 and 1998 EC datasets had p31c16_1-p31c16_6 detail. Other datasets had only for seasonal workers. the same is true for p31c15
p32c5 variable is only for 1991 EC data and it doesn't have detailed_1 like value for each occupation
slry_u2m..... are only for 2005 and 2006 GC
serialno10 p41c4_10.... are only present in 1997 and 1998 GC data sets
inv4 and its summary isn't present in all the dataset
invno and its average, end of the year and within year cost estimates are available only to the 1997 and 1998 GC datasets
Mulu thesis ' due to inconsistensy in id-numbers and isic clasificn, we deleted 9 observations. we also found a large no. of firms entering and exiting multiple times (7%) they are excluded from productivity analysis due to a problem in construction a capital stock'
I dropped serialno10 p41c4_10 p41c5_10 p41c6_10 p41c7_10 p41c9_10 p41c11_10
I droped rawno10, p61c4_10, p61c5_10, and all p61c_10 variables which were supposed to contain total sum of items 1-9
fuelub7 is only present in 1997 and 1998 EC datasets
fuelub7 and its details are dropped as we arleady have total
I dropped p62c8_1 p62c8_2 p62c8_3 p62c8_4 p62c8_5 p62c8_6 p62c8_7
p62c10_1 p62c10_2 p62c10_3 p62c10_4 p62c10_5 p62c10_6 p62c10_7
p62c10_1 p62c10_2 p62c10_3 p62c10_4 p62c10_5 p62c10_6 p62c10_7 are dropped
p62c11_1 p62c11_2 p62c11_3 p62c11_4 p62c11_5 p62c11_6 p62c11_7 are droped
p62c12_1 p62c12_2 p62c12_3 p62c12_4 p62c12_5 p62c12_6 p62c12_7 are dropped
p62c13_7 p62c13_6 p62c13_5 p62c13_4 p62c13_3 p62c13_2 p62c13_1 are dropped
p62c14_1 p62c14_2 p62c14_3 p62c14_4 p62c14_5 p62c14_6 p62c14_7 are dropped
p71c3 p71c3_7 are dropped
drop p71c4 p71c4_7
drop p71c5 p71c5_7
drop p71c6 p71c6_7
FA7 p71c7_7 p71c7
p72c4_6 p72c3_6 invt6
drop pdtno10 p81c4_10 p81c5_10 p81c6_10 p81c7_10
drop RMno7 p82c4_7 p82c5_7 p82c6_7
percnt_full starts 1994 EC onwards. no data for 1988-1993
marm_WPF male working propritors, partners and family workers
marf_WPF female working propritors, partners and family workers
marfr_WPF foreigner working propritors, partners and family workers
drop sptm_ST sptf_ST sptfr_ST decm_ST decf_ST decfr_ST marm_ST marf_ST marfr_ST junm_ST junf_ST junfr_ST
p31c8 empty thus droped
this dataset will try to reduce the variables which do not seem to be used in my analyis
if the variables I will be droping are needed later on, I can merege them to the 09042009_panel dataset or any updated version of the data from now on.
there is a need to edit eid (establishment id). So try to keep the editing commands so that you will edit all the datasets. this is crucial for merging variables from different datasets
netinvt_Tot is based onegen netinvt_Tot=rowtotal( netinvt_DH netinvt_NRB netinvt_CW netinvt_MCEQ netinvt_Veh netinvt_FF) if netinvt_Tot_mis<6