## Sort regression output

For technical questions regarding estimation of single equations, systems, VARs, Factor analysis and State Space Models in EViews. General econometric questions and advice should go in the Econometric Discussions forum.

Moderators: EViews Gareth, EViews Moderator

chris_cl
Posts: 9
Joined: Tue Nov 27, 2018 2:18 am

### Sort regression output

I use the

Code: Select all

`dummy*@expand(@year*@month,@dropfirst)`
command to interact a dummy with a bunch of time dummies. I was wondering if there is any way to sort the regression output without coping everything to Excel? Eviews sorts the output according to the product of @month*year which is rather useless if I want to analyze the coefficients over time.

chris_cl
Posts: 9
Joined: Tue Nov 27, 2018 2:18 am

### Re: Sort regression output

Some feedback would be great.

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

### Re: Sort regression output

There's nothing built in.

You could freeze the output into a table and then sort the table, but to be honest you're probably best off just creating the dummies yourself and putting them in whichever order you want.

chris_cl
Posts: 9
Joined: Tue Nov 27, 2018 2:18 am

### Re: Sort regression output

Quick follow up on this one:

How can I specify a specific period instead of the first one? This

Code: Select all

`@expand(@month*@year,@drop(@month*@year={number}))`

command produces the near singular matrix problem, it works fine if I use @dropfirst instead.{number} is the value of the product of @month*@year, e.g. {number]=2010 in 2010M01.

chris_cl
Posts: 9
Joined: Tue Nov 27, 2018 2:18 am

### Re: Sort regression output

As suggested, I created a dummy series for each period. However, now I cannot simply use something like

Code: Select all

`time_fe*dummy`

Is it really necessary to write a program to get the the interaction?

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

### Re: Sort regression output

I'm not entirely sure I understand the issue. If time_fe is a series, and dummy is a series, why can't you multiply them?