EViews.com

Did you try running our example codes?

Yes, like I said, unfortunately none of the examples worked out. The code i posted was my attempt after running both your ideas first.

Thanks for the idea and effort. Unfortunately, none of the suggestions did work out, as both of them filled y with the last value of x, from the last cross section. for !i=1 to 1018 smpl if @crossid=!i series adjtrend = @recode(x<>na, @trend, na) series lasttrend = @maxsby(adjtrend, @crossid) series...

I have another question. If I have a panel, and would like to extract the last value of each cross section, that is not NA, in a series, into a new one, and fill all observations within that cross section with the same value. How would one address this issue? I made an example below. X symoblises th...

So you don't really want to stack them at all. You want to merge them into one series that is of the same length (i.e. in the example file you want a series that has 7,208 observations). How about putting the four series into a group, then taking the rowwise mean: group g stack1 stack2 stack3 stack...

.xls files are limited to 64k rows. That's a Microsoft limit, nothing to do with EViews. I believe .xlsx files can have up to 1024k rows. Allright I had a lot more than that, but then the export did not work out well. Anyway you could send us the files? I think it should be pretty easy and straight...

I'm not quite sure I understand what you're trying to do. You currently have a workfile with a panel structure with 1016 cross-sections, and 5 million total row (so, about 5,000 time periods). In that panel workfile you have 4 series. You want to stack those 4 series into one giant series. How will...

I have a panel with 1016 cross sections and total ~5 million observations. In the data set, I have 4 different series, that contains data that of the same variabel. I want to merge these 4 together, as one series in a panel. 95% of the observation are NA. There might be some overlapping, where the d...

Base it on the cross-section number.

If you want to remove all cross-sections over 500, then use:

Code: Select all

pagecontract if @crossid<500

Thanks Gareth, that worked.

obsid refers to the "time" dimension. Do you have more than 4,982,617 observations per cross-section . If you don't, then contracting based on obsid will do nothing. I've got a daily date range from 1995 - 2015 with 1020 cross section units, with 4948020 observations (unique in time and c...

What happens when you write the following into the command line and run? pagecontract if @obsid<4928617 You seem to have ~5 million observations, whereas EViews allows 4 million per series by default. So, if you have not changed the default settings (Options/General Options), then your series might...

Hi, I would like to contract my workfile and exclude all obsid>4928616. I entered the following statement in the Wokfile Contract option, but it does not have any effect. 01/01/1995 01/01/2015 if @obsid<4928617 Copy and pasting the data into a new page is not an option since its too many observation...

Thank you very much Gareth! Works like a charm when the series are modified for missing values.

Good evening, I'm trying to program a script to extract observations from different series into a new one. I have series in the naming format of aW_Y & bW_Y where W=week number and Y=year. Example: a01_06, b52_96. The observations are dated about 5 times a week, and I want to take the 7th last o...