Export p-values to excel

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

econviews
Posts: 3
Joined: Tue Sep 08, 2020 7:04 am

Export p-values to excel

Postby econviews » Mon Oct 12, 2020 6:30 am

Hi everyone,

I'm working with a large dataset where I perform granger tests with several countries. I prepared a program that performs the granger test for all countries with several lags.
What I'm trying to do now is to export the p-values to an excel file where I have e.g. column A with country A and then the p-values for 1 lag in row 2, 2 lags in row 3 etc.

Any help would be appreciated!
Thanks!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
Joined: Tue Sep 16, 2008 5:38 pm

Re: Export p-values to excel

Postby EViews Gareth » Mon Oct 12, 2020 8:44 am

Use the freeze command to freeze the output into a table, then extract the p-values from that table into a vector/matrix/table, then at the end save that vector/matrix/table.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests