Display or export graph data from custom graphs - panel data

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

DCFerral
Posts: 7
Joined: Thu Sep 22, 2016 6:28 pm

Display or export graph data from custom graphs - panel data

Postby DCFerral » Tue Sep 27, 2016 12:48 am

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

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

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

Postby EViews Gareth » Tue Sep 27, 2016 9:06 am

graph.makegroup is the only option.
Follow us on Twitter @IHSEViews

DCFerral
Posts: 7
Joined: Thu Sep 22, 2016 6:28 pm

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

Postby DCFerral » Tue Sep 27, 2016 7:44 pm

Thank you for your reply Gareth, could you provide any detail on how graph.makegroup is used in the context of panel data?

EViews Glenn
EViews Developer
Posts: 2671
Joined: Wed Oct 15, 2008 9:17 am

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

Postby EViews Glenn » Wed Sep 28, 2016 9:41 am

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.

DCFerral
Posts: 7
Joined: Thu Sep 22, 2016 6:28 pm

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

Postby DCFerral » Tue Oct 04, 2016 5:57 pm

Thanks for the suggestion Glenn*, I'll do something like that.

Edit*


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 21 guests