How to obtain a table with by-group statistcs easily in EVIEWS?

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

mamo
Posts: 82
Joined: Wed Nov 07, 2012 9:11 am

How to obtain a table with by-group statistcs easily in EVIEWS?

Postby mamo » Wed Nov 30, 2016 6:52 am

Dear EVIEWS'ers ,

I have always found it cumbersome to generate a table-like overview over group-wise descriptive stats out of panel/structured data in EVIEWS.

The program below generates a workfile with two variables x and y in a panel design in the page "panel" and a corresponding pool structure in the page "pool".

How can I quickly obtain a tabular presentation of some descriptive statistics, e.g., the mean, of the expression x/y for each of the cross sections, and perhaps also over two different samples, for example the samples s1 and s2 - either in the panel or in the pool structure?

Obviously, a longer program can do this, but could such a basic and often-needed task of data examination also be achieved faster with one to two command lines? Or is there an add-on around which would do the job?

(So, I am missing kind of the powerful and user-friendly "tabulate" command and by-group statistics as implemented in a well-known competitor of EVIEWS.)

Best, mamo

Code: Select all

wfcreate(page=panel) q 2000q1 2015q4 10
series x=nrnd
series y=10+nrnd
alpha cid=@chr(64+crossid)
pagestruct cid @date(dateid)
delete crossid
sample s1 "2000Q1 2008Q4"
sample s2 "2009Q1 2015Q4"
pageunstack(page=pool, namepat="?*") cid dateid @ x y
delete dateid
copy panel\s*

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

Re: How to obtain a table with by-group statistcs easily in EVIEWS?

Postby EViews Gareth » Wed Nov 30, 2016 8:12 am

View->descriptive statistics->stats by classification
Follow us on Twitter @IHSEViews

mamo
Posts: 82
Joined: Wed Nov 07, 2012 9:11 am

Re: How to obtain a table with by-group statistcs easily in EVIEWS?

Postby mamo » Fri Dec 02, 2016 4:21 am

Thank you very much, this was helpful; indeed there is also the .statby-view for the command line which I have not been aware of so far.
Best, mamo


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 2 guests