Search found 122 matches

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: 191

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: 191

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: 86

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: 86

@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: 191

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: 191

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: 191

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: 76

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: 335

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: 133

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: 266

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: 266

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...
by mamo
Thu Feb 07, 2019 5:33 am
Forum: Data Manipulation
Topic: Export data to R
Replies: 2
Views: 163

Re: Export data to R

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...
by mamo
Fri Jan 18, 2019 7:40 am
Forum: Bug Reports
Topic: x.sheet(w) - wide view of sheet command not working from program or commandline
Replies: 1
Views: 197

x.sheet(w) - wide view of sheet command not working from program or commandline

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...
by mamo
Fri Dec 14, 2018 9:09 am
Forum: Suggestions and Requests
Topic: Showing only selected sample in pool.sheet
Replies: 1
Views: 602

Showing only selected sample in pool.sheet

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

Go to advanced search