Table 1: the glm using family gaussian link identity, however these could now be considered "incorrect" as the log transform did not normalise the data.
The use of log-transformation or log-link is correct or not to the extent that it reflects the actual data generating model. If the effect of an increase in the exposure variable is to multiply the outcome by a certain fraction, then a log-linked or log-transformed model is correct. If the effect of an increase in the exposure variable is to add a fixed increment to the outcome, then a log-linked or log-transformed model is incorrect. One might get a sense of that by looking at the expected outcomes when the exposure = 0, 1, and 2. If the expected outcomes go up like a geometric sequence, then logging makes sense. If they look more like an arithmetic sequence, then an untransformed regression (or id link) would be more appropriate.
The two models you show, a linear regression on log-transformed data and a log-linked regression on untransformed data are related but different models. The former estimates the expectation of log(outcome); the later estimates log(expectation of outcome). Since logarithm is a non-linear function, these two expressions are different. So you cannot expect the two models to give closely matching results. Nonetheless, they might well be fairly close.
I have to say that reading your outputs, to me the models are saying more or less the same thing. They show minor quantitative differences, but nothing that strikes me as substantial. In particular, in the case of both the crude and adjusted models. the coefficient in the log-transformed model lies well within the confidence limits of the log-linked model and vice-versa. To the rather loose precision that these models' parameters are estimated by your data, they are not really distinguishable from each other. The models are really quite consistent with each other. The difference in principle between these models is subtle and it would take sharp estimation to distinguish them with confidence:: a model based on a noisy measure like an FFQ has little hope of doing that.
Comment