Search found 169 matches
- 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...
- 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...
- 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?
- 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
- 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.
- 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?
- 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 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.
- 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.
- 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...
- 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?
- 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.
- 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...
- 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"?
- 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?
- 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...