How to use IF command

[truetears]

Hi guys, I want to know how I can use the IF command to restrict the data group to only specific values, what I mean is, in the file attached, in the "distance" group, I want to restrict the spreadsheet so that it only shows values for which distance>7403.77, how do I do this?

Thanks :)

[EViews Gareth]

You need to use a sample.

Code: Select all

smpl if x>7

[truetears]

Sorry I am quite new to Eviews 7, what exactly does that mean? I have clicked on window and enter in "distance > 7403.77" in the IF space, then it comes up with the number of observations which satisfies the IF condition, however I wish to actually restrict the spreadsheet of the group "distance" such that only the observations that are greater than 7403.77 are shown rather than the whole spreadsheet.

Thanks!

[EViews Gareth]

That's exactly what you have done.

[truetears]

That's exactly what you have done.

But when I open up "distance" it still shows me all 1000 observations? I can't see the 221 restricted observations.

[EViews Gareth]

Hit the SMPL +/- button.

[truetears]

Thank you! exactly what I was looking for :)

[EViews Gareth]

Note that hitting the SMPL+/- button only changes the view you are currently looking at. The current sample is applied to any statistics you perform, whether or not you have hit that button.

[truetears]

Ahh I see, thanks for that, just out of curiosity then, how would I be able to use only the restricted sample in regression analysis?

[EViews Gareth]

By default it will use the restricted sample - as I said, once you have set the restricted sample it generally gets used for everything you do after that.