Programming the statistical procedures from SAS

Missing values in a significant variable during the modelling process

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 92
Accepted Solution

Missing values in a significant variable during the modelling process

Hi.

During the Modelling process, if we have selected some of the variables and we see that for one of the very significant variable the values are missing so is there a threshold or industry specified % for the variable to be kept in the model and ignore the missing values.

I understand that we can replace the missing values with either the mean or the median of the variable however wanted to see if statisitcally there is a threshold.

Regards, Shivi


Accepted Solutions
Solution
‎11-11-2014 09:58 AM
Trusted Advisor
Posts: 1,222

Re: Missing values in a significant variable during the modelling process

Hi,

I think there is no standard threshold for variables with missing values to be considered for modeling. Normal practice is to drop a variable having 50% missing values. If you consider variable having 50% missing values is important for modeling, then you can create an indicator variable and use that instead.

View solution in original post


All Replies
Solution
‎11-11-2014 09:58 AM
Trusted Advisor
Posts: 1,222

Re: Missing values in a significant variable during the modelling process

Hi,

I think there is no standard threshold for variables with missing values to be considered for modeling. Normal practice is to drop a variable having 50% missing values. If you consider variable having 50% missing values is important for modeling, then you can create an indicator variable and use that instead.

Frequent Contributor
Posts: 92

Re: Missing values in a significant variable during the modelling process

thank you.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 224 views
  • 0 likes
  • 2 in conversation