Hey guys,

my goal is to regress the natural logarithm of total industry sales and an index variable of years, with time serving as independent variable and take then, the antilog of the regression coefficient capturing the growth rate of sales.

In order to calculate that I used the following command

bys sic_d: gen sales = sum(sale)

gen sales_log=log(sales)

bys sic: asreg sales_log y1, wind(fyear 5)rec coef
drop _R2 _adjR2 _b_y1 _b_cons _coef_cons _Nobs [... this command ist repeated accordingly for every year].

However, it generates an error message after the the third line telling me "option coef" not allowed (it works fine if I calculate the standard error by using "se" instead of "coef").

Do you guys have any idea how to solve that?

Nick Cox Clyde Schechter maybe you guys have any idea since you have solved similar problems before?