Contract workfile drop panel observations

[bananen]

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.

Code: Select all

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 observations to be stored in the memory.

[trubador]

What happens when you write the following into the command line and run?

Code: Select all

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 not have those observations at all.

[bananen]

What happens when you write the following into the command line and run?

Code: Select all

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 not have those observations at all.

That did not work either.

I have already changed to the maximum allowance, I think that Eviews gave a warning when the ceiling was hit.


But thanks for the thought and input.

[EViews Gareth]

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.

[bananen]

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 cross section) in total.

When I open up a series, right click and select ObsID, it is shown next to the cross section unit and its date. This is a list that in my workfile looks to go from 1 to 4948020. Hence I thought that @obsid refered to a unique observation specified in both cross section and time dimension.

All ObsID>4928616 are part of cross section units that I want to remove from my workfile.

Which would be the proper approach to do this?

[EViews Gareth]

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

[bananen]

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.