Search found 12 matches

by Andre2016
Wed Nov 30, 2016 12:47 am
Forum: Programming
Topic: Match Merge unstructured
Replies: 0
Views: 3932

Match Merge unstructured

Hello, I have the attached workfile. When I try the following command, there is not value for defl in the fleetcalc page: pageselect Fleetcalc copy gdpdefl\defl Fleetcalc\ @src year @dest year How do I do a match merge using "year" as the criteria to copy defl from the gdpdefl page to flee...
by Andre2016
Tue Nov 29, 2016 11:04 pm
Forum: Data Manipulation
Topic: Error 500 on structuring panel data in eviews
Replies: 1
Views: 3038

Error 500 on structuring panel data in eviews

Hello all, I am trying to restructure the attached excel data into a panel data in eviews but I have an error 500 500. First I am importing it as unstructured data then I am trying to restructure it into a dated panel as per the following: Date series : year Cross section ID series : Ascendmodel SEG...
by Andre2016
Tue Oct 04, 2016 1:27 pm
Forum: Programming
Topic: @wdrop statement
Replies: 6
Views: 5973

Re: @wdrop statement

bbmodel = @replace(bbmodel, "SPX", "") I have an issue. when I do bbmodel = @replace(bbmodel, "Falcon 200", "Falcon 20") All the values containing "Falcon 200***" changes e.g: Falcon 2000S becomes Falcon 200S Is there a solution so that when I chang...
by Andre2016
Mon Sep 26, 2016 11:37 am
Forum: Programming
Topic: @wdrop statement
Replies: 6
Views: 5973

Re: @wdrop statement

Code: Select all

bbmodel = @replace(bbmodel, "SPX", "")
Thanks Gareth,
by Andre2016
Mon Sep 26, 2016 11:23 am
Forum: Programming
Topic: @wdrop statement
Replies: 6
Views: 5973

Re: @wdrop statement

Currently those lines are not doing anything, so hard so see what you mean. I have a series called "bbmodel" which is an alpha series that I'd like to edit. In that alpha series I'd like the following action: If what appears is "Astra 1125SP" then I'd like it to be only "As...
by Andre2016
Fri Sep 23, 2016 1:07 pm
Forum: Programming
Topic: @wdrop statement
Replies: 6
Views: 5973

@wdrop statement

Hello Guys, So I have the following code : smpl @all genr bbmodel = bbdmodel alpha bbmodel @wdrop ("Astra 1125SP" , "SP") @wdrop ("Astra 1125SPX" , "SPX") Is there a way to write it so that I don't have to revrite the @wdrop statement on every single line? Tha...
by Andre2016
Sat Sep 03, 2016 10:40 pm
Forum: Programming
Topic: Goup loop
Replies: 2
Views: 3053

Re: Goup loop

Code: Select all

group fleetbyageall num*
(assuming there aren't any other nums you don't want in the group).


For the second one, if they're already in a group you can use @rsum. Otherwise, no.
Thank you
by Andre2016
Sat Sep 03, 2016 9:05 pm
Forum: Programming
Topic: Goup loop
Replies: 2
Views: 3053

Goup loop

Hello, Is there a more efficient ways to write the following codes ? group fleetbyageall num1 num2 num3 num4 num5 num6 num7 num8 num9 num10 num11 num12 num13 num14 num15 num16 num17 num18 num19 num20 num21 num22 num23 num24 num25 num26 num27 num28 num29 num30 num31 num32 num33 num34 num35 num36 num3...
by Andre2016
Fri Sep 02, 2016 10:41 pm
Forum: Data Manipulation
Topic: Merging 2 workpages
Replies: 6
Views: 6384

Re: Merging 2 workpages

When you do the copy/paste it will ask you if you want to merge the objects.
I solved the issue using pageappend.

Thanks
by Andre2016
Fri Sep 02, 2016 2:48 pm
Forum: Data Manipulation
Topic: Merging 2 workpages
Replies: 6
Views: 6384

Re: Merging 2 workpages

Copy them from the source page, Paste Special on the destination page, and use General Match Merge. Then enter the ID series you want to use. Thanks Gareth. The issue is when I try to do that, since my old and new data have the same name (for example in the attached workfile, I have "year"...
by Andre2016
Thu Sep 01, 2016 8:29 pm
Forum: Data Manipulation
Topic: Merging 2 workpages
Replies: 6
Views: 6384

Re: Merging 2 workpages

We'll need more information on exactly what you mean Hi Gareth, So I have 2 pages in the same workfile : page1 called "FLEETBYAGE19601999" Page2 called "FLEETBYAGE20002016" both pages have the same format and I'd like to merge the two in one page without deleting any data Thanks
by Andre2016
Thu Sep 01, 2016 5:21 pm
Forum: Data Manipulation
Topic: Merging 2 workpages
Replies: 6
Views: 6384

Merging 2 workpages

Hello, I have a workfile with 2 pages and I'd like to merge them into one. Some series in the 2nd page don't exist in the 1st one and I'd like them to be integrated using 3 criteria (here: model, category and country). https://s10.postimg.org/6012dt21h/Capture.png I try to use the following command ...

Go to advanced search