Search found 12 matches
- 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...
- 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...
- 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...
- Mon Sep 26, 2016 11:37 am
- Forum: Programming
- Topic: @wdrop statement
- Replies: 6
- Views: 5973
Re: @wdrop statement
Thanks Gareth,Code: Select all
bbmodel = @replace(bbmodel, "SPX", "")
- 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...
- 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...
- Sat Sep 03, 2016 10:40 pm
- Forum: Programming
- Topic: Goup loop
- Replies: 2
- Views: 3053
Re: Goup loop
Thank you(assuming there aren't any other nums you don't want in the group).Code: Select all
group fleetbyageall num*
For the second one, if they're already in a group you can use @rsum. Otherwise, no.
- 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...
- Fri Sep 02, 2016 10:41 pm
- Forum: Data Manipulation
- Topic: Merging 2 workpages
- Replies: 6
- Views: 6384
Re: Merging 2 workpages
I solved the issue using pageappend.When you do the copy/paste it will ask you if you want to merge the objects.
Thanks
- 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"...
- 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
- 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 ...
