!cd .. !cd .. !cd c:\wages\ven\data /* 1975*/ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch75.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test75, replace /* 1976*/ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch76.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test76, replace /* 1977 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch77.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test77, replace /* 1978 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch78.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test78, replace /* 1979 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch79.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test79, replace /* 1981 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch81.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test81, replace /* 1982 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch82.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test82, replace /* 1983 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch83.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test83, replace /* 1984 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch84.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test84, replace /* 1985 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch85.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test85, replace /* 1986 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch86.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test86, replace /* 1987 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch87.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test87, replace /* 1988 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch88.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test88, replace /* 1989 */ drop _all set maxvar 254 width 2098 set more 1 infile using c:\wages\ven\dict.dct, using (c:\wages\ven\data\punch89.dat) keep w88 m9 m10 m13 n20 n21 n18 n19 l4 l5 l6 x2 x3 s1 s2 pindex plevel cost7 test4 x4 x11 year c2 e2 l13 l14 i91 sic weight save test89, replace */ /* and now to append all the years into one data set */ drop _all set maxobs 70000 use test75 append using test76 append using test77 append using test78 append using test79 append using test81 append using test82 append using test83 append using test84 append using test85 append using test86 append using test87 append using test88 append using test89 gen sales=s2*pindex gen royal=cost7*plevel label var sales "Sales (undeflated)" label var royal "Royalty payments (undeflated)" sort year sic x2 x3 !cd .. !cd .. !cd .. !cd c:\stata\ven save test, replace drop _all use test sort year sic collapse sales royal, by(year sic) sum(sales royal) gen royalty=royal/sales sort year sic save royal, replace