BookmarkSubscribeRSS Feed
Question
Fluorite | Level 6

Hi ,

 

I have used the code below to impute the missing from a Survey that I am working on.

 

My goal is to make sure that after imputation, the distribution of variables of imputed recipients matches the distribution of donors (non missing). But I am having a problem with the variable region, after imputation the distribution isn't matching the donors (see below). Is there anyway, to fix this region distribution in the code below, is there any option that will make every region representative etc..?

 

Thank you

 

proc surveyimpute data=hotdeck_source method=hotdeck(selection=ABB);

ndonors=5 seed=773269;

   var income;

   class var1 var2 var3 var4 var5;

   Id unitID;

   cells var1 var2 var3 var4 var5
   output out=hotdeck_result1 donorid;

run;

 

Donors   Imputed recipients
Region Percentage   Region Percentage
East Midlands 8%   East Midlands 1%
East of England 6%   East of England 0%
London 5%   London 10%
North East 5%   North East 0%
North West 10%   North West 1%
Northern Ireland 5%   Northern Ireland 75%
Scotland 19%   Scotland 5%
South East 11%   South East 2%
South West 8%   South West 2%
Wales 5%   Wales 1%
West Midlands 8%   West Midlands 3%
Yorks and the Humber 9%   Yorks and the Humber 0%

 

 

2 REPLIES 2
gcjfernandez
SAS Employee
Try SAS Surveyimpute method=FEFI (Efficient Fractional Imputation (FEFI). Please refer the paper: https://support.sas.com/resources/papers/proceedings16/SAS3520-2016.pdf
Question
Fluorite | Level 6

Thank you Fernández, will try.

 

Best wishes

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

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