Search found 169 matches

by paues
Fri Apr 05, 2013 1:28 pm
Forum: Programming
Topic: Exporting dates to xlsx?
Replies: 8
Views: 7888

Re: Exporting dates to xlsx?

Thank you for your extensive answer! And please excuse my vague question. (I was planning to ask a different question originally, but changed my mind mid-writing, leaving traces of the initial questions in the text.) Your '@keep @date' pointer solved my problem (together with the arguments 'noid' an...
by paues
Fri Apr 05, 2013 6:13 am
Forum: Programming
Topic: Exporting dates to xlsx?
Replies: 8
Views: 7888

Exporting dates to xlsx?

Is it possible in EViews 8 to export dates to xlsx files alongside data? And is it possible to export dates only? And is it possible to stop the series names from being exported with the data? Now, I can get the command to export data only with the command below. wfsave(t=excelxml, mode=update, noid...
by paues
Fri Apr 05, 2013 3:32 am
Forum: Suggestions and Requests
Topic: Export data to existing excel file
Replies: 13
Views: 13456

Re: Export data to existing excel file

Please note that the example provided by davey87 was not updated in the documentation that comes with EViews 8. Is it possible for you to update it in when you release patches?
by paues
Thu Apr 04, 2013 9:11 am
Forum: Programming
Topic: Pagecontract NAs
Replies: 4
Views: 3650

Re: Pagecontract NAs

Thanks! More and more I get the feeling that groups are the answer to all my questions :-)
by paues
Thu Apr 04, 2013 8:08 am
Forum: Programming
Topic: Pagecontract NAs
Replies: 4
Views: 3650

Re: Pagecontract NAs

Any series. That is, if the page range originally is 1900 1910 and there are two series, one dating from 1901 to 1905 and the other from 1904 to 1909, then I would like for the page range to be 1901 1909 after the contraction.
by paues
Thu Apr 04, 2013 8:06 am
Forum: Programming
Topic: Pagecontract NAs
Replies: 4
Views: 3650

Pagecontract NAs

In EViews 8, is there any easy way to contract a page so that the sample only includes periods for which there is at least one observation?
by paues
Thu Mar 07, 2013 3:12 am
Forum: Programming
Topic: Simpler way to maximize control variables?
Replies: 4
Views: 3983

Re: Simpler way to maximize control variables?

Together with a loop that could be the one :D Should have thought about it myself, now that I see it. I was struggling to find something native to EViews - odd that there does not seem to be anything.
by paues
Thu Mar 07, 2013 2:29 am
Forum: Programming
Topic: Simpler way to maximize control variables?
Replies: 4
Views: 3983

Re: Simpler way to maximize control variables?

Thank you for that. But although I neglected to mention it in my original post I am looking for a solution that can be scaled to maximize over any number of values.
by paues
Thu Mar 07, 2013 2:05 am
Forum: Programming
Topic: Simpler way to maximize control variables?
Replies: 4
Views: 3983

Simpler way to maximize control variables?

I have two control variables (containing date values) and I want to create a third control variable for the maximum of the two control variables. How do I do this? It should be really easy, but here I am, fiddling with matrices. Is there no simpler way than what I come up with below? !D1=@dateval(&q...
by paues
Sun Feb 03, 2013 2:21 am
Forum: Suggestions and Requests
Topic: Saving table as Excel file
Replies: 2
Views: 3849

Re: Saving table as Excel file

How is it going with this? Will it be possible to save tables as Excel files in EViews 8? If so, in what format? .xls? .xlsx? .xlsm?
by paues
Thu Jan 31, 2013 1:09 am
Forum: Programming
Topic: Retrieving date format?
Replies: 9
Views: 5831

Re: Retrieving date format?

"NA" I guess :-) To me that seems exactly the type of example that would leave also @dateval puzzled. I am not at my computer right now but I presume that @dateval("10/11/12") would similarly return NA.
by paues
Wed Jan 30, 2013 11:28 pm
Forum: Programming
Topic: Retrieving date format?
Replies: 9
Views: 5831

Re: Retrieving date format?

That was precisely what I meant :-) Would you consider adding it? It seems that the functionality is already there as the code below yields the expected result. !mydateval=@dateval("2012Q3") Ideally, there would be a @dateformat function that takes a date string, e.g. "2012Q3", a...
by paues
Wed Jan 30, 2013 3:27 pm
Forum: Programming
Topic: Retrieving date format?
Replies: 9
Views: 5831

Re: Retrieving date format?

Alright. But is there any way to retrieve the format of an arbitrary date? So, that I from "2010Q3" could get "YYYY[Q]Q"?
by paues
Wed Jan 30, 2013 2:33 pm
Forum: Programming
Topic: Retrieving date format?
Replies: 9
Views: 5831

Re: Retrieving date format?

A page's sample/range is specified by two dates. Those dates have format. Is there someway to retrieve that format? Or, for that matter, the format for any arbitrary date string?
by paues
Wed Jan 30, 2013 2:41 am
Forum: Programming
Topic: Overwrite argument to copy command?
Replies: 0
Views: 1751

Overwrite argument to copy command?

What is the difference between using the copy command with and without the overwrite argument? The results seem to be identical (see code below). close @all wfcreate(page=p1) a 2005 2010 series x=1 series y=1 pagecreate(page=p2) a 2000 2010 series x=2 series y=2 copy p1\x copy(overwrite) p1\y show x...

Go to advanced search