all variables except emp is given in thousands. Emp is just in nominal terms.
assume end of year stays constant through out period 1994-2004
correct year end from fame by 'replace year=year+1 if month <=3'
do file creating this is C:\fame_from_j\dvd_downloads\making_long8
original file is x:\fame\DINESH_22MARCH05.asc
reshaped to long format
created on: 23 Mar 2005 12:17
is created based on criteiria that turnover and emp must be >0 in any given year.
comes from february 2005 dvd
This is the part 4 German data file revised to include bvd and mq variables. These were merged in using the do file "C:\DATA\Hart Hanks\Italy\Do Files\german name cleaning and matching.do".
This is the part 4 German data file revised to include bvd and mq variables. These were merged in using the do file "C:\DATA\Hart Hanks\Germany\Do Files\german name cleaning and matching.do".
do file- c:\wages\nick_wages
There is a problem when using post 1996 data becasue they shift from SIC to Naics convention. Hence due to inaccuavwagee matching between pre and post 1997, there is often a jump in the values of emp and pay, and hence the avwage. I constrain the avwage to increase from 1996 to 1997 by 5% for all sic codes to avoid this problem. This is the 'new avwage'. I do not change the actual values of emp and pay, just the avwage. Hence avwage=newavwage up to 1997 and then avwage~=newavwage. newavwage should be used in all analysis.
23 Nov 2004 12:25
Source data: Pre 1997- Bartelsman& Gray, 1997 onwards-US Census, contact: Hilda Ward
Made by :D.Cheryan