https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562469#M10747 <P>I have 65 categorical variables and all of them have around 15% missing values. It would be great if you can help me to suggest how to impute missing values for categorical variables.</P> Thu, 30 May 2019 04:49:04 GMT apxprdtr10 2019-05-30T04:49:04Z https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562469#M10747 <P>I have 65 categorical variables and all of them have around 15% missing values. It would be great if you can help me to suggest how to impute missing values for categorical variables.</P> Thu, 30 May 2019 04:49:04 GMT https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562469#M10747 apxprdtr10 2019-05-30T04:49:04Z https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562479#M10749 <P>Well, it depends largely on what you want to do with the data.. However, you can use <A href="https://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_stdize_syntax.htm&amp;docsetVersion=14.3&amp;locale=en" target="_self">PROC STDIZE</A> to impute the data.&nbsp;</P> <P>&nbsp;</P> <P>Also, see the article&nbsp;<A href="https://blogs.sas.com/content/iml/2017/12/04/mean-imputation-sas.html" target="_self">Mean imputation in SAS</A>&nbsp;where some issues with mean imputation are highlighted.</P> Thu, 30 May 2019 06:49:10 GMT https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562479#M10749 PeterClemmensen 2019-05-30T06:49:10Z https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562483#M10750 <P>I want to impute mode values for missing categorical variables.</P> Thu, 30 May 2019 07:07:54 GMT https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562483#M10750 apxprdtr10 2019-05-30T07:07:54Z https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562487#M10751 <P>Ok. Do you have By Groups in your data?</P> Thu, 30 May 2019 08:00:17 GMT https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562487#M10751 PeterClemmensen 2019-05-30T08:00:17Z https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562508#M10752 <P>yes</P> Thu, 30 May 2019 10:37:33 GMT https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562508#M10752 apxprdtr10 2019-05-30T10:37:33Z https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562542#M10764 <P>One way is using its MODE to replace missing.</P> <P>Another smart way is using PROC MI .</P> Thu, 30 May 2019 12:48:19 GMT https://communities.sas.com/t5/New-SAS-User/missing-values-for-categorical-variables/m-p/562542#M10764 Ksharp 2019-05-30T12:48:19Z