BookmarkSubscribeRSS Feed

Missing Value Imputation

Started ‎02-04-2022 by
Modified ‎02-04-2022 by
Views 6,601

I published a paper in the Southeast SAS Users' Group meeting in 2021 on the topic of missing value imputation, and I am sharing it with the SAS community.

 

I describe the purpose of missing values, historical attempts to solve the imputation problem that missing values represent, and present a detailed analysis of census data containing missing values. I developed SAS macros to impute missing values using Fuzzy c-Means clustering, and I share my work so that others may profit from what I have created.

 

Comments

Hi Team,

 

I've used the below code for multiple imputation. After doing imputation, I'm running multinomial logistic regression then running proc analyse. And getting only pooled/combined estimates. But I need relative estimates.

Thank you.
.
.

proc mi data=data.newdata seed=876 nimpute=5 out=outfcs;

class group sex hispan;

fcs nbiter=40 logistic (group/details);

var group sysbp01 diabp01 a1c_01 chol_01 bmi_01 sex hispan;

run;

 

proc logistic data = outfcs;

class group (ref = "3") sex (ref = "0") hispan (ref= "1") / param = ref;

model group = sysbp01 diabp01 a1c_01 chol_01 bmi_01 age01 sex hispan / link = glogit covb;

by _Imputation_;

ods output ParameterEstimates=lgsparms CovB=lgscovb;

run;

 

proc mianalyze parms (classvar=classval)=lgsparms;

class sex hispan;

modeleffects intercept sysbp01 diabp01 a1c_01 chol_01 bmi_01 age01 sex hispan ;

run;

Version history
Last update:
‎02-04-2022 05:20 PM
Updated by:
Contributors

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

SAS AI and Machine Learning Courses

The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.

Get started

Article Tags