export icon indicating copy to clipboard operation
export copied to clipboard

Export splm object

Open alexmufeq opened this issue 2 years ago • 1 comments

Hi! I'm trying to export an splm regression, because I saw here that is possible. But I have an error:

Error in table2spreadsheet(..., type = "XLS") : splm is currently not supported by table2office

Is there still a way to export a splm object?

Here is the code:

library(splm)
library(export)

#loading data
data(Insurance)
data(itaww)

# preparing regression
w <- mat2listw(itaww)
reg <- log(ppcd) ~ log(rgdp) + log(bank) + log(den) + rirs +
  log(agen) + school + vaagr + log(fam) + d99 + d00 +
  d01 + d02 

# splm reg

splm_reg <- spml(reg, data = Insurance, listw =w, model="pooling", spatial.error="none",  lag=FALSE)

#exporting splm regression
table2excel(splm_reg, file=filen, sheetName="x", digits = 1, digitspvals = 3)

alexmufeq avatar Aug 16 '22 16:08 alexmufeq

Sorry it seems that xtable, which export depends on, dropped support for a bunch of models & there is also no tidy method for splm objects. Best to ask the authors of either xtable or broom about that to see if they would mind supporting splm objects once more...

tomwenseleers avatar Dec 01 '22 17:12 tomwenseleers