Direct transformations of db referenced series

[mamo]

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


[EViews Gareth]

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

[EViews Gareth]

i.e.

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

[mamo]

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


[EViews Gareth]

ok, we'll fix.