EViews.com

Hi everybody,

I need to export the results of panel regression, i.e. predicted and actual series and residuals for multiple countries into excel in an unstacked single country version. If one generates residuals after running panel data one gets all in one series in stacked version. I need the code to unstack it and export it to excel.

For instanse, for single regression it looks like: wfsave(type=excelxml) "c:\za.csv" @keep za_cds5y za_prcds5y za_resid

could you please explain me how one can do it for the whole panel?

Thanks in advance.

You'll have to use the pageunstack command to unstack the resid series into a pooled workfile page first, then save from the pooled workfile page.