Search found 14 matches

by vivienle
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!
by vivienle
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...
by vivienle
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
by vivienle
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.
by vivienle
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?
by vivienle
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!
by vivienle
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.
by vivienle
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.
by vivienle
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!
by vivienle
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
by vivienle
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...
by vivienle
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...
by vivienle
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...
by vivienle
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 ...

Go to advanced search