EViews.com

Dear Steve, many thanks for the swift reply. One reason for sourcing out SQL code in an external text file such as sql1.txt is the wish to make a longer SQL query more easily readable by structuring it across several lines. Then, with the solution you suggest, lines in sql1.txt would become rows in ...

Dear Eviews team, I use EVIEWS 10+ SQL query code can become very long when retrieving data from an odbc source through the wfopen(type-odbc) or the respective import command and selecting the data in an SQL query. Is there a way to "outsource" the SQL query commands in a separate file whe...

Dear Eviews team I use Eviews 10 March 2018 build it seems that expressions used as arguments in table procedures such as deleterow and deletecol are not interpreted as expected. The example tab.deleterow 5-!x would not work as expected . Table procedures seem to interpret only the first part of the...

Dear Eviews teasm as a user of Eviews 10 March 18 build, I remember that I encountered the same issue in the past. Having read this post, I digged a bit deeper. - The phenomenon appears in workpages with number of observations (@obsrange) >= 10 in the first place. If @bsrange < 10, any figure is rep...

Dear Eviews team, I use Eviews 10+ March 2018 build Is there a straightforward approach to restructuring an unstructured workfile page so as to obtain a regular dated panel structure? See example program below. Best mamo wfcreate u 50 series crossid=@ceiling(@obsid/10) 'How can this be restructured ...

You are right, and honestly, after second thoughts, the first suggestion does not work at all. If anything, the divisor should be sth like @ceiling([number of crosssections]/[number of quantile]. But even that would not in general provide the desired result. The reason is that the actual values of t...

Hi, you may try the following, obtaining the dummy series du series du=@ceiling(@groupid(@ranks(@meansby(u,crossid, "@all"),a,l))/4) Alternatively, assuming that there are no NA's in the @last period: dv=1 for !i=1 to 4 series dv=dv+(@meansby(u,fund, "@all")>=@quantile(@meansby(u...

Hi, "2000Q1" 2000Q2" ... you see in the output from the print command are just the row names of the R-dataframe and not one of the variables generated with the xput command. Why would the row-names bother you? A way to removing the row names from the R-data.frame would be inserting ro...

Dear Eviews team, I use EVIEWS 10+ March 2018 build. The wide (w)-option in the sheet-command for series seem to work as described in the help-documentation if the option is used in a program or command window call of .sheet - see the example program below. Among other things, this disallows program...

Dear Eviews team I use Eviews 10+ March 2018 build. The programme below shows that freezing a pool-sheet freezes in fact the full sample rather than only the pre-selected one. This happens even though I do have the following options set: Spreadsheets - Layout - Series spreadsheets - One column data ...

Dear Eviews team using the @expand-function in the rhs of an equation can give rise to an implausible labelling of the estimated paramters, see for example the programme below. With the programme provided below, the estimated parameters for the dummy-interaction terms from equation ls y c x x*@expan...

I now understand - took a bit longer, apologies (also inspecting a db containing a series coming from a panel wf helped). So the suggestion would be that series coming from a wf page with a panel structure should be stored together with some pieces of structural information in a db: 1) as it is stan...

I think, there are two issues here which should not be mixed up: first, structure-consistent references of panel data: the panel structure of the series in the targeted wf conforms with the structure of the referring wf page in use. Second structure-inconsistent copying (and reference) of panel data...

Many thanks for your answer Luckily EViews will interpret a workfile as a database, so it does in general work. However, since databases don't support panels, when using this hack, panel information is lost Contrary to what you say, it seems that EVIEWS databases do support panel structures. The cod...

Dear Eviews team, I use Eviews 10+, March 2018 I detected unexpected behavior of EVIEWS when trying to access a series (named x) from an open panel file (named f2) which is different from the one in use (named f1) - both files having the same panel structure. show f2::x does not show the series x in...