Search found 14 matches
- Mon Apr 27, 2015 11:45 am
- Forum: Data Manipulation
- Topic: Convert date string to date value
- Replies: 4
- Views: 4822
Re: Convert date string to date value
Thanks! It works!
- Mon Apr 27, 2015 11:24 am
- Forum: Data Manipulation
- Topic: Convert date string to date value
- Replies: 4
- Views: 4822
Re: Convert date string to date value
Hello, I did look at @dateval. But I need to provide the format of the date string and I don't know what I'm supposed to use as formats shown in the manual are all in normal date formats such as "mm/dd/yyyy", "month dd, yyyy". So, @dateval("1999M02", "what do I put...
- Mon Apr 27, 2015 10:56 am
- Forum: Data Manipulation
- Topic: Convert date string to date value
- Replies: 4
- Views: 4822
Convert date string to date value
Hello,
I'm trying to convert a date string in the format of 1999M02 (date string obtained from: smpl if seriesX <> na, %firstdate = @otods(1)) to a date value. Could you please help? I've been looking and googling but can't figure out how.
Thanks,
vivien
I'm trying to convert a date string in the format of 1999M02 (date string obtained from: smpl if seriesX <> na, %firstdate = @otods(1)) to a date value. Could you please help? I've been looking and googling but can't figure out how.
Thanks,
vivien
- Wed Apr 15, 2015 1:12 pm
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
I tried reversing the two lines and reversing the order of lags in the short-form. Both scenarios have similar delays as before. Thanks.
- Wed Apr 15, 2015 12:48 pm
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
You mean reverse the order of the two command lines?
- Wed Apr 15, 2015 12:44 pm
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
Thanks for your help!
- Wed Apr 15, 2015 11:38 am
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
I installed the latest patch which brings me up to "Oct 17 2013 build" and ran the program again. But not much improvement.
time1 = 0.010000
time2 = 22.42800
Thanks.
time1 = 0.010000
time2 = 22.42800
Thanks.
- Wed Apr 15, 2015 11:12 am
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
I'll install the patches and then try again. If I still have problem after that, can I just reply to this topic?
Thanks.
Thanks.
- Wed Apr 15, 2015 11:00 am
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
Version 7.2; Enterprise Edition - Jun 2 2011 build
Thanks!
Thanks!
- Wed Apr 15, 2015 9:39 am
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
Hi,
So I did as you said.
time1 (all variables listed) = 0.006000
time2 (short-form) = 23.61100
So what went wrong then?
Thanks again,
viv
So I did as you said.
time1 (all variables listed) = 0.006000
time2 (short-form) = 23.61100
So what went wrong then?
Thanks again,
viv
- Wed Apr 15, 2015 9:14 am
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Re: Long run time in ls regression with lagged variables
Hi, I copied out the codes from my original program to test it out. I literally watch the screen as the program runs and it definitely takes a lot longer when it runs the last line (the short-form) versus the second last which does the exact same thing. My data is pulled from Haver. Here're the code...
- Wed Apr 15, 2015 8:46 am
- Forum: Estimation
- Topic: Long run time in ls regression with lagged variables
- Replies: 15
- Views: 11875
Long run time in ls regression with lagged variables
Hello, I'm experiencing unusually long run time in ls regressions with lagged independent variables when I use the short-form (see below) instead of listing out each of the lagged variables. Is there anything I can do to reduce the execution time of the short-form, especially when I want to repeat t...
- Wed Jan 23, 2013 10:19 am
- Forum: Data Manipulation
- Topic: Date format using wfsave
- Replies: 2
- Views: 4416
Re: Date format using wfsave
Hi Chris, Thanks for your quick response!!! So I added @enddate and I did get an extra column with the end dates. For some reason, Excel seems to have problem reading the dates. For example, the value is "01/31/1950 12:00:00 AM" but it's displayed as "02/01/1950 12:00:00 AM" in E...
- Wed Jan 23, 2013 7:59 am
- Forum: Data Manipulation
- Topic: Date format using wfsave
- Replies: 2
- Views: 4416
Date format using wfsave
Hello, I am using the following command line to export monthly series that end in _hp to Excel using wfsave. wfsave(2,t=excel,maptype=n) "W:\EViews\test_write_potential.xls" @keep *_hp The dates exported are in the format of YYYY/MM/DD showing the first date of each month. I actually want ...
