Search found 125 matches

by mamo
Wed Aug 14, 2019 3:37 am
Forum: Bug Reports
Topic: Logaritmic scaling in graphs - does it work?
Replies: 1
Views: 132

Logaritmic scaling in graphs - does it work?

Dear Eviews team, using EVIEWS 10 March 2018 build, I am wondering if logarithmic scaling in graphs works as expected. Changing the scale from linear to logarithmic does not seem to change anything in the appearance of the graph, c.f. code below. Best, mamo wfcreate a 2000 2010 series x= @trend^2 fr...
by mamo
Wed Jul 31, 2019 8:39 am
Forum: Data Manipulation
Topic: Question on graphing panel data
Replies: 2
Views: 97

Re: Question on graphing panel data

Many thanks - works, but gives rise to an ugly observation labeling (though this can be rectified by making cx a appropriately defined alpha series as well). This leads me to suggest an improvement: implement an additional panel option - such as "panel=interleave" - to the respective graph...
by mamo
Wed Jul 31, 2019 8:00 am
Forum: Data Manipulation
Topic: Question on graphing panel data
Replies: 2
Views: 97

Question on graphing panel data

Dear Eviewers graphing panel data using the "line" command with the option "p=stack" generates a line chart which shows the series as ordered first along the cross sections and secondly along the time dimension. In the example code shown below this would be 1-2000 1-2001 1-2002 ....
by mamo
Wed Apr 24, 2019 1:31 am
Forum: Data Manipulation
Topic: SQL code in separate file when reading data from an ODBC source?
Replies: 7
Views: 788

Re: SQL code in separate file when reading data from an ODBC source?

Hello,
this is good news, many thanks!
Best, mamo
by mamo
Tue Apr 23, 2019 6:31 am
Forum: Data Manipulation
Topic: SQL code in separate file when reading data from an ODBC source?
Replies: 7
Views: 788

Re: SQL code in separate file when reading data from an ODBC source?

... and furthermore, I also found that @wread automatically removes commas from the text it reads in, and it seems that this unwanted behaviour cannot be switched off. This renders @wread useless as a command for reading in structural code, such as sql code. So, I again repeat my request to the Evie...
by mamo
Tue Apr 23, 2019 6:22 am
Forum: Bug Reports
Topic: @wread buggy?
Replies: 1
Views: 341

Re: @wread buggy?

... and furthermore, @wread removes commas in the original text, and includes text after a comma in double quotation marks automatically, see text3.txt and str3 in the expanded example code below. Appears to be a rather strange behaviour. Could the Eviews team kindly correct this unwanted behavior o...
by mamo
Fri Apr 12, 2019 8:19 am
Forum: Bug Reports
Topic: @wread buggy?
Replies: 1
Views: 341

@wread buggy?

Dear Eviews team, I use Eviews 10 March 2018 build. At least in this version, the command @wread seems to be buggy: 1) @wread encloses lines in quotes which is not wanted, and it does so inconsistently. See example below: lines read from text1.txt are enclosed in double quotes, not so lines read fro...
by mamo
Fri Apr 12, 2019 8:14 am
Forum: Data Manipulation
Topic: SQL code in separate file when reading data from an ODBC source?
Replies: 7
Views: 788

Re: SQL code in separate file when reading data from an ODBC source?

Indeed, @wread comes close to what I have in mind. Unfortunately, however, @wread seems to be buggy - at least in version Eviews 10 March 2018 build, which renders this command largely inappropriate for my purposes: 1) @wread encloses lines in quotes which is not wanted, and it does so inconsistentl...
by mamo
Fri Apr 12, 2019 12:06 am
Forum: Data Manipulation
Topic: SQL code in separate file when reading data from an ODBC source?
Replies: 7
Views: 788

Re: SQL code in separate file when reading data from an ODBC source?

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 ...
by mamo
Thu Apr 11, 2019 2:46 am
Forum: Data Manipulation
Topic: SQL code in separate file when reading data from an ODBC source?
Replies: 7
Views: 788

SQL code in separate file when reading data from an ODBC source?

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...
by mamo
Tue Feb 26, 2019 3:48 am
Forum: Suggestions and Requests
Topic: Table procedures cannot interpret expressions provided as arguments in a programme
Replies: 0
Views: 418

Table procedures cannot interpret expressions provided as arguments in a programme

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...
by mamo
Thu Feb 21, 2019 3:24 am
Forum: Data Manipulation
Topic: Problem with numbers converted to dates
Replies: 10
Views: 916

Re: Problem with numbers converted to dates

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...
by mamo
Mon Feb 11, 2019 1:22 am
Forum: Data Manipulation
Topic: How to restructure an unstructured page to a regularily dated panel?
Replies: 1
Views: 464

How to restructure an unstructured page to a regularily dated panel?

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 ...
by mamo
Fri Feb 08, 2019 4:18 am
Forum: Data Manipulation
Topic: Creating quantile samples in paneldata
Replies: 4
Views: 585

Re: Creating quantile samples in paneldata

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...
by mamo
Thu Feb 07, 2019 7:17 am
Forum: Data Manipulation
Topic: Creating quantile samples in paneldata
Replies: 4
Views: 585

Re: Creating quantile samples in paneldata

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...

Go to advanced search