Search found 21 matches

by Chthoniid
Thu Oct 24, 2019 6:22 pm
Forum: Programming
Topic: Hints for "for" loop in nested hierarchy
Replies: 3
Views: 3312

Re: Hints for "for" loop in nested hierarchy

Got it all figured
by Chthoniid
Wed Oct 23, 2019 1:49 pm
Forum: Programming
Topic: Hints for "for" loop in nested hierarchy
Replies: 3
Views: 3312

Re: Hints for "for" loop in nested hierarchy

Ah, sorry. I import the data from a csv file, as unstructured data. Screenshot added. ID is the highest level, this branches into sruvey_qnumber (1-9) and this branches into 1-4 alternatives. My goal is to collate and aggregate each of the 4 alternative rows into one row, using select variable value...
by Chthoniid
Tue Oct 22, 2019 7:36 pm
Forum: Programming
Topic: Hints for "for" loop in nested hierarchy
Replies: 3
Views: 3312

Hints for "for" loop in nested hierarchy

My data is organised as following hierarchy: 1843 subjects, each with 9 sets of questions across 4 alternatives. For each set of 4 alternatives I want to find the highest value of one variable (if it is present). So everything I do I want to do on each set of 4 alternatives. for !i=1 to 1843 for !j=...
by Chthoniid
Fri May 27, 2016 2:17 pm
Forum: Programming
Topic: FOR loops and @month headache
Replies: 3
Views: 1716

Re: FOR loops and @month headache

Got it, sorry, where date is the original date series

M=@datepart(date, "mm")
by Chthoniid
Fri May 27, 2016 1:32 pm
Forum: Programming
Topic: FOR loops and @month headache
Replies: 3
Views: 1716

Re: FOR loops and @month headache

EViews Gareth wrote:Does M contain the full date or just the month?


M contains the full date. I can't seem to find a function/syntax that extracts just the month info
by Chthoniid
Thu May 26, 2016 9:02 pm
Forum: Programming
Topic: FOR loops and @month headache
Replies: 3
Views: 1716

FOR loops and @month headache

Appreciate the help I've been getting, but have it a new snag. Series M is the date of each observation. E.g. 1993-08-26 I can't seem to figure out a way to extract just the month from this series, in a 1 to 12 format. Which I can use in the following FOR/NEXT loop. (The actual year part in loop run...
by Chthoniid
Wed May 25, 2016 2:12 am
Forum: Programming
Topic: What's efficient way
Replies: 2
Views: 1484

Re: What's efficient way

EViews Gareth wrote:What structure do your data have?

It might be that something like:
[code]
...
will work.


Brilliant, works perfectly. Thanks
by Chthoniid
Tue May 24, 2016 10:39 pm
Forum: Programming
Topic: What's efficient way
Replies: 2
Views: 1484

What's efficient way

I'm still a novice when it comes to programming, and have a problem. I've got a large data set, based on roughly 20,000 hunters and 15 years. What I want is the minimum length of each alligator for each hunter, for each year. The current code is for !year = 2000 to 2014 smpl if harvestyear=!year for...
by Chthoniid
Tue May 24, 2016 5:11 pm
Forum: Data Manipulation
Topic: Coding String/Character series as Numeric
Replies: 3
Views: 1818

Re: Coding String/Character series as Numeric

Excellent- the proc/map is beautifully simple
by Chthoniid
Mon May 23, 2016 8:24 pm
Forum: Data Manipulation
Topic: Coding String/Character series as Numeric
Replies: 3
Views: 1818

Coding String/Character series as Numeric

I've got a data series that is just a list of village names in PNG. I'd like to assign each one a unique numeric code (to make programming For/NEXT loops easier). So Village A gets value of 1, village B 2, Village C 3 etc. I'm just not seeing in programming or command reference how to achieve this.....
by Chthoniid
Thu Apr 28, 2016 2:08 pm
Forum: Data Manipulation
Topic: Stacking raw data - help
Replies: 3
Views: 1734

Re: Stacking raw data - help

Thanks- I suspect there's something very simple I've overlooked.

File attached
by Chthoniid
Wed Apr 27, 2016 7:24 pm
Forum: Data Manipulation
Topic: Stacking raw data - help
Replies: 3
Views: 1734

Stacking raw data - help

Hi all- I'm on Eviews 9 for the first time. I'm trying to import data in a very irregular format, and shape it into something I can work with. It's not working. The data records the number of butterflies caught by each collector in each village in PNG. E.g. Date YR Collector Town Q P TR 26 August 19...
by Chthoniid
Sun Sep 21, 2014 4:45 pm
Forum: Econometric Discussions
Topic: VECM model and rank
Replies: 0
Views: 1085

VECM model and rank

I'm afraid VECM regressions are pushing me into unfamiliar territory. I have 4 equations. The Johansen test identified 4 cointegrating equations. I have two exogenous variables as well. I'm trying to get my head around what the 'rank' should be and I don't get it. Could I get a little bit of help he...
by Chthoniid
Mon Sep 01, 2014 3:36 pm
Forum: Econometric Discussions
Topic: Time trend in VECM trouble
Replies: 1
Views: 1051

Re: Time trend in VECM trouble

I'm afraid you can't include time trends.
A VECM is estimated on differenced data, so is detrended.
Perhaps some period dummies may work if it is just some periods that interest you?
by Chthoniid
Sun Aug 24, 2014 1:42 am
Forum: Data Manipulation
Topic: The elusive @datediff
Replies: 2
Views: 1574

Re: The elusive @datediff

Ok, that's the first basic problem solved.

Change the value display from days.

Now just to work out how to find the numeric value of specific dates.

Go to advanced search