EViews.com

Posted: **Fri Feb 17, 2017 4:31 am**

Dear Eviews team
I use Eviews 9.5 March 17 2016 build.

Are direct transformations of series stored in a database, such as

Code: Select all


show d(dbn::x)

meant to be feasible in Eviews?

If so I am wondering about an unexpected result in circurmstances similar to the ones generated by the programme below.
In short, it seems that

Code: Select all


show d(db1::x) d(db2::x)

unexpectedly shows d(db1::x) in both columns.
In contrast

Code: Select all


show (db1::x) (db2::x)

works as expected.
What is wrong here?

Best, mamo

Example code

Code: Select all


' Create two wfs, testdb1 and testdb2, to be used as dbs later on
wfcreate(wf=testdb1) a 2000 2015
series x=0
smpl @first+1 @last
series x=x(-1)+1
smpl @all
wfsave testdb1
wfclose  testdb1
wfcreate(wf=testdb2) a 2000 2015
series x=0
smpl @first+1 @last
series x=x(-1)+2
smpl @all
wfsave testdb2
wfclose  testdb2
' Assign handles to wf names
db testdb1.wf1 as db1
db testdb2.wf1 as db2
' Create new wf
wfcreate a 2000 2015
' unexpectedly, the 2nd column does not show 1st differences
' of x taken from test2, but rather taken from test1
show d( db1::x ) d(db2::x) 
' In contrast, showing series from dbs without transformation 
'  works as expected
'  show db1::x db2::x

Posted: **Fri Feb 17, 2017 5:04 am**

It is supposed to work, and does, I think. When I ran your code, I received the expected result.

Posted: **Fri Feb 17, 2017 5:26 am**

i.e.

: 2017-02-17_145720.png (49.48 KiB) Viewed 4354 times

Posted: **Fri Feb 17, 2017 5:34 am**

Hi,

indeed, it works as intended if the name of the working directory does not contain spaces (like "c:\temp" as in your example).

Otherwise, the result I have reported can be replicated.

The code below is the same as before, except the 2nd line which changes to a working directory with a "spacy" name.

Best,
mamo

Code: Select all


' Change to a directory with spaces in the name
cd "C:\temp\This is a test dir" 
' Create two wfs, testdb1 and testdb2, to be used as dbs later on
wfcreate(wf=testdb1) a 2000 2015
series x=0
smpl @first+1 @last
series x=x(-1)+1
smpl @all
wfsave testdb1
wfclose  testdb1
wfcreate(wf=testdb2) a 2000 2015
series x=0
smpl @first+1 @last
series x=x(-1)+2
smpl @all
wfsave testdb2
wfclose  testdb2
' Assign handles to wf names
db testdb1.wf1 as db1
db testdb2.wf1 as db2
' Create new wf
wfcreate a 2000 2015
' unexpectedly, the 2nd column does not show 1st differences
' of x taken from test2, but rather taken from test1
show d( db1::x ) d(db2::x) 
' In contrast, showing series from dbs without transformation 
'  works as expected
'  show db1::x db2::x

Posted: **Fri Feb 17, 2017 5:40 am**

ok, we'll fix.

EViews.com

Direct transformations of db referenced series

Direct transformations of db referenced series

Re: Direct transformations of db referenced series

Re: Direct transformations of db referenced series

Re: Direct transformations of db referenced series

Re: Direct transformations of db referenced series