observations with N/A reducing the sample

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

rob86
Posts: 13
Joined: Sun Jun 17, 2012 10:00 pm

observations with N/A reducing the sample

Postby rob86 » Thu Jul 05, 2012 4:42 am

Hello (accidentally posted this in the econometrics discussions forum so sorry about repost)

I have a sample of 500 firms with around 50 explanatory variables. Out of the around 30000 observations there are 2000 N/A's. When I run the regression the sample size is reduced by any firm with has an N/A in any of the explanatory variables which leaves around 200 of the 500 firms. Is there any way to keep the whole sample of 500 firms when some of the observations are N/A's? or will an N/A in any of the explanatory variables always remove the firms from the sample?

Thanks

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: observations with N/A reducing the sample

Postby startz » Thu Jul 05, 2012 6:02 am

Hello (accidentally posted this in the econometrics discussions forum so sorry about repost)

I have a sample of 500 firms with around 50 explanatory variables. Out of the around 30000 observations there are 2000 N/A's. When I run the regression the sample size is reduced by any firm with has an N/A in any of the explanatory variables which leaves around 200 of the 500 firms. Is there any way to keep the whole sample of 500 firms when some of the observations are N/A's? or will an N/A in any of the explanatory variables always remove the firms from the sample?

Thanks
The latter. It's called listwise deletion.

rob86
Posts: 13
Joined: Sun Jun 17, 2012 10:00 pm

Re: observations with N/A reducing the sample

Postby rob86 » Thu Jul 05, 2012 12:21 pm

thanks for second answer in two days startz, anyone have an opinion on using Hot deck imputation when <4% of observations are missing? would this have any major negative impacts?


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests