Search found 31 matches

by bcchen
Fri Jan 17, 2020 10:26 am
Forum: Programming
Topic: compare script version comparison
Replies: 4
Views: 5751

Re: compare script version comparison

Thanks Matt.

Just wondering, with these software, will us be able to use the prg file directly or has to save as a text file to compare?

Appreciate that.

Best,
BC
by bcchen
Thu Jan 16, 2020 12:27 pm
Forum: Programming
Topic: compare script version comparison
Replies: 4
Views: 5751

compare script version comparison

Hi Guys,

Is there a way I can compare the two programming files written and show how the program has been changed as a version control? Additional software needed?

Thanks,
BC
by bcchen
Thu Jan 09, 2020 11:49 am
Forum: Programming
Topic: delete all valmap objects
Replies: 3
Views: 5074

Re: delete all valmap objects

Thank you! That works!
So I guess for tables can I changes "valmap" to "table"?
by bcchen
Fri Jan 03, 2020 3:18 pm
Forum: Programming
Topic: delete all valmap objects
Replies: 3
Views: 5074

delete all valmap objects

Hi EViews gurus,

Is there a way in programming to delete all the valmaps objects with no naming rules all at once? also, same for tables?

Thanks in advance.
BC
by bcchen
Wed Apr 10, 2019 3:03 pm
Forum: Programming
Topic: @datediff between quarter end
Replies: 2
Views: 2723

Re: @datediff between quarter end

I am using EVIEWS 9.5
by bcchen
Wed Apr 10, 2019 3:03 pm
Forum: Programming
Topic: @datediff between quarter end
Replies: 2
Views: 2723

@datediff between quarter end

Hi Eviews fellows, I was trying to calculate quarter difference between some quarter end dates and found something weird: =@datediff(@dateval("2011-09-30"),@datefloor(@dateval("2011-06-30"),"Q"),"Q") the result is 1; =@datediff(@dateval("2011-06-30")...
by bcchen
Tue Dec 04, 2018 11:24 am
Forum: Data Manipulation
Topic: import excel files with wildcard in names
Replies: 2
Views: 3385

Re: import excel files with wildcard in names

Thank you very much Gareth! it works like a charm!
by bcchen
Wed Nov 28, 2018 10:37 am
Forum: Data Manipulation
Topic: import excel files with wildcard in names
Replies: 2
Views: 3385

import excel files with wildcard in names

Hi EVIEWS GURUS, I have many excel file in a folder that I want to import all of them to EVIEWS. The name of the excel files vary, but all end with "reviewed". Is that possible to write a program: 1. pick out all the excel files in a certain folder and import them(then I will remove those ...
by bcchen
Fri Oct 26, 2018 12:02 pm
Forum: Data Manipulation
Topic: password lock workfile
Replies: 1
Views: 5480

password lock workfile

Hi, is there a way to password lock workfile, so that others cannot open/edit it?

Thanks.
BC
by bcchen
Fri Sep 15, 2017 8:01 am
Forum: Data Manipulation
Topic: create a series using @dateceil() not working
Replies: 3
Views: 3761

create a series using @dateceil() not working

Hi, I have a series called "quarter" that contains dates, which is the first day of the quarter. I want to create a quarter_ceil=@dateceil(quarter,"Q"), but it generates error message saying @DATECEIL is not a Genr or series expression function. Did I do something wrong? How do I...
by bcchen
Thu Sep 14, 2017 5:46 pm
Forum: Data Manipulation
Topic: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?
Replies: 2
Views: 3525

Re: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

Thank you Matt.
Hope there will be an @firstby() for alpha series soon.

Best,
BC
by bcchen
Tue Sep 05, 2017 4:39 pm
Forum: Data Manipulation
Topic: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?
Replies: 2
Views: 3525

SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

Hi Guys, I want to get the first observation of a alpha series(alpha1) each time another two series's value changes (alpha2 and series3). I know we have @fistsby for numeric series, is there any formula (or formula communication) that I could do something like: alpha alpha1_new=@firstsby(alpha1, alp...
by bcchen
Mon Aug 28, 2017 1:13 pm
Forum: Data Manipulation
Topic: unable to change tabulation-freezed table value column format
Replies: 2
Views: 3528

Re: unable to change tabulation-freezed table value column format

Thank you Gareth.
Your way does solve my problems.

Best,
BC
by bcchen
Mon Aug 28, 2017 12:11 pm
Forum: Data Manipulation
Topic: unable to change tabulation-freezed table value column format
Replies: 2
Views: 3528

unable to change tabulation-freezed table value column format

Hi, I have a question regarding changing the format of a table. I freeze a frequency tabulation of a date series called "quarter" to a table, (for each "*_ipu" series missing ones) and append them into a spool: missing_qtr_distr Below are my codes: spool missing_qtr_distr %fieldl...

Go to advanced search