Page 1 of 1

Display or export graph data from custom graphs - panel data

Posted: Tue Sep 27, 2016 12:48 am
by DCFerral
Hi Eviews support,
My institution requires graphs to be made with a third-party software. Is it possible to export a graph into spreadsheet form, so it can be graphed externally?

Example: I use panel data and make use of the 'categorical graphs' functionality to simplify the data into three useful aggregates (Local, foreign, and unclassified, over time). The eviews graph is great and shows three time series as desired.
To export the data, I tried using the code:

Code: Select all

graph.makegroup Sales_by_producer

But the resulting group only had one time series which could not be used (it is not entirely clear what this did).

As a work-around I've generated series using the @sumsby(,date,producer_type) and @meansby(,date,producer_type) commands and then narrowed the sample to one cross section from each category, then copy-pasted the data into excel.

However, this workaround is not really friendly enough to be more widely adopted for analysis at my institution. Is there a way to export processed graph data to spreadsheet form?
Thanks again for all your help.
Diego

Re: Display or export graph data from custom graphs - panel data

Posted: Tue Sep 27, 2016 9:06 am
by EViews Gareth
graph.makegroup is the only option.

Re: Display or export graph data from custom graphs - panel data

Posted: Tue Sep 27, 2016 7:44 pm
by DCFerral
Thank you for your reply Gareth, could you provide any detail on how graph.makegroup is used in the context of panel data?

Re: Display or export graph data from custom graphs - panel data

Posted: Wed Sep 28, 2016 9:41 am
by EViews Glenn
Not to interrupt the conversation, but for what it's worth, the by-group method that you describe can be done using only simple commands so that you can avoid the copy-and-paste. Further, you could create a simple program add-in to do the operation automatically.

Re: Display or export graph data from custom graphs - panel data

Posted: Tue Oct 04, 2016 5:57 pm
by DCFerral
Thanks for the suggestion Glenn*, I'll do something like that.

Edit*