Page 14 of 14

Re: How to enter data into a panel workfile.

Posted: Wed May 18, 2016 12:23 am
by alper
Hello ,Gareth.

Now it worked beatifully. Honestly speaking, I had checked the dates several times before sending my previous message. However only after your message was I able to realize doublicate 2012Q2 with missing 2011Q1. That should be a good example for selective perception.

Thank you very very very much : ))

Re: How to enter data into a panel workfile.

Posted: Tue Jul 05, 2016 7:09 pm
by econ07
Hello Gareth,

I have not used eviews for panel regressions before and need some help setting up a panel workfile.
I am trying to set up a workfile for 52 US states for six variables over 1979-2015 at a quarterly frequency.
I am fetching all the data from the Haver database using an Eviews programe as I want future updates to be made as quickly as possible.

I have seen that you have given some detailed examples on how to turn excel files into panel workfiles, but not if the data is imported directly from the database. Sorry if I missed sth. Can you help with this question please?

Many thanks in advance.

Re: How to enter data into a panel workfile.

Posted: Tue Jul 05, 2016 7:48 pm
by EViews Gareth
You cannot fetch directly into a panel workfile. You'll have to fetch into a pool, then convert.

Re: How to enter data into a panel workfile.

Posted: Wed Jul 06, 2016 4:31 am
by econ07
Thanks a lot for your relpy.
Does that mean I need to fetch as individual time series, convert into a pool and then convert into a panel workfile? Or is there a way to fetch directly into a pool and convert from there? If the the latter could you please share how to do it?

Re: How to enter data into a panel workfile.

Posted: Wed Jul 06, 2016 7:41 am
by EViews Gareth
I should have been more specific - you need to fetch the individual time series into a pool-like workfile, and then convert into a panel. You don't need to actually create a pool object.

Re: How to enter data into a panel workfile.

Posted: Wed Jul 06, 2016 1:44 pm
by econ07
Hi Gareth,

I am using Eviews 9 and I fetch the follwoing data among others.
This is gives me a pool like workfile as there are some common patterns here, for each series the first two letters refer to the state and the rest to the series.
I tried using a command you suggest in an earlier post, pagestack.

'pagestack(wf=STATE_HP) ?hpi ?hst ?rbtq ?yppq ?ra ?l14 ?fcm30 @ *? *

But with the ? at the start as that is where my cross section identifiers are located. My final results do not resemble a cross section however. Any idea what could be the problem?


fetch(d=usecon) fcm30

fetch(d=regional) ALHPI AKHPI AZHPI ARHPI CAHPI COHPI CTHPI DEHPI DCHPI FLHPI GAHPI HIHPI IDHPI ILHPI INHPI IAHPI KSHPI KYHPI LAHPI MEHPI MDHPI MAHPI MIHPI MNHPI MSHPI MOHPI MTHPI NEHPI NVHPI NHHPI NJHPI NMHPI NYHPI NCHPI NDHPI OHHPI OKHPI ORHPI PAHPI RIHPI SCHPI SDHPI TNHPI TXHPI UTHPI VTHPI VAHPI WAHPI WVHPI WIHPI WYHPI

fetch(d=regional) AKHST AZHST ARHST CAHST COHST CTHST DEHST DCHST FLHST GAHST HIHST IDHST ILHST INHST IAHST KSHST KYHST LAHST MEHST MDHST MAHST MIHST MNHST MSHST MOHST MTHST NEHST NVHST NHHST NJHST NMHST NYHST NCHST NDHST OHHST OKHST ORHST PAHST RIHST SCHST SDHST TNHST TXHST UTHST VTHST VAHST WAHST WVHST WIHST WYHST

fetch(d=uspop) ALRBTQ AKRBTQ AZRBTQ ARRBTQ CARBTQ CORBTQ CTRBTQ DERBTQ DCRBTQ FLRBTQ GARBTQ HIRBTQ IDRBTQ ILRBTQ INRBTQ IARBTQ KSRBTQ KYRBTQ LARBTQ MERBTQ MDRBTQ MARBTQ MIRBTQ MNRBTQ MSRBTQ MORBTQ MTRBTQ NERBTQ NVRBTQ NHRBTQ NJRBTQ NMRBTQ NYRBTQ NCRBTQ NDRBTQ OHRBTQ OKRBTQ ORRBTQ PARBTQ RIRBTQ SCRBTQ SDRBTQ TNRBTQ TXRBTQ UTRBTQ VTRBTQ VARBTQ WARBTQ WVRBTQ WIRBTQ WYRBTQ

Re: How to enter data into a panel workfile.

Posted: Wed Jul 06, 2016 6:00 pm
by rif
Colleagues, could you please share commands to import unbalanced panel data from excel into eviews? Thank you.

Re: How to enter data into a panel workfile.

Posted: Thu Jul 07, 2016 8:18 am
by rif
Colleagues, could you please share commands to import unbalanced panel data from excel into eviews? Thank you.

Re: How to enter data into a panel workfile.

Posted: Thu Jul 07, 2016 8:44 am
by startz
What happens when you drag the Excel file onto EViews?

Re: How to enter data into a panel workfile.

Posted: Sat Jul 09, 2016 7:39 am
by rif
I am trying to read a panel data from excel into eviews using the commands below (but unsuccessfully). Is there anything wrong with the commands? Thank you.

workfile X_M a 1945 2015

pool poolall _arg _arm _aus _aut _bel _bol _bra _bgr _bfa _khm _cmr _can _tcd _chl _chn _col _cod _cog _civ _cze _dnk _egy _est _eth _fin _fra _geo _deu _gha _grc _hti _hnd _hkg _hun _isl _ind _idn _irl _isr _ita _jpn _jor _kaz _ken _kor _lao _lva _ltu _mdg _mys _mla _mex _mda _mar _moz _mmr _npl _ndl _nzl _nic _nga _nor _pak _per _phl _pol _prt _rou _rus _sau _sen _sgp _svk _svn _zaf _esp _sdn _swe _che _tza _tha _tur _uga _ukr _gbr _usa _uzb _vnm _yem _zmb

poolall.read(e2, s=Combined) C:\Users\IX\My_Local_Documents\I\Research\X_M\Database\X_M.xls ner_ecos? neer_ecos? reer_l_ecos? rec_ecos? brer_ecos? rgdp_g_ecos? pgdp_g_ecos? usrgdp_g_ecos?

Re: How to enter data into a panel workfile.

Posted: Fri Mar 15, 2019 4:52 am
by brinde
Hi Gareth,

I'm trying to organise panel data according to the second type of format that you've laid out using the Eviews 10 University edition.
Unfortunately, I can only manage to get past the initial step of stacking my years, and can't seem to get past the second step of unstacking the variables.
I've spent a decent amount of time trying to figure it out online myself, but without any luck.
I've attached both my excel and workfile, and would greatly appreciate any help here.

Many thanks!

Re: How to enter data into a panel workfile.

Posted: Fri Mar 15, 2019 7:54 am
by EViews Gareth
Looks like you have a few data errors. If you open up REGION, VAR01 and VARIABLE as a group, then click on View->N Way Tabulation, only check "Count", and uncheck the "Group into bins" options, you'll get a tabulation of all the combinations of values. There should be only one combination of each. But there isn't. For example, there are two observations for Nord-Est for variable sizeoffinance for each year.

Re: How to enter data into a panel workfile.

Posted: Mon Mar 18, 2019 10:42 am
by brinde
EViews Gareth wrote:Looks like you have a few data errors. If you open up REGION, VAR01 and VARIABLE as a group, then click on View->N Way Tabulation, only check "Count", and uncheck the "Group into bins" options, you'll get a tabulation of all the combinations of values. There should be only one combination of each. But there isn't. For example, there are two observations for Nord-Est for variable sizeoffinance for each year.


Thanks a lot Gareth, much appreciated!