BookmarkSubscribeRSS Feed
yw2757
Fluorite | Level 6

Multiple imputation: using proc freq procedure to summarize an imputation dataset (number of imputation=5). The statistics need to find are "proportion of responders" and "95%CI of proportion". 

 

PROC FREQ DATA= Impdsin;
  By NIMPUTE;
  Table TRTN*depvar / RiskDiff(Equal CL=(Wald));
  Ods Output RiskDiffCol2 = Imp_propci01 (Where=(Index(Row, 'Row')));
  Ods Output RiskDiffCol2 = Imp_diffci01 (Where=(Index(Row, 'Difference')));
RUN;

 

PROC MIANALYZE DATA = Imp_propci01;
  By TRTN;
  Modeleffects Risk ;
  Stderr ASE ;
  ODS Output
  ParameterEstimates= Imp_propci_Miana;
RUN;

 

Warning Appear because 

yw2757_0-1620759727975.png

yw2757_1-1620759747551.png

 

Anyway to solve this issue?

 

Thank you!

 

 

 

1 REPLY 1
ballardw
Super User

When there is no variability for a variable within a group the SdtErr is 0. Can't be "fixed" as that comes from you data.

 

Example:

data example;
  input x y;
datalines;
1   23
1   22
1   24
2   18
2   18
2   18
2   18
;

proc means data=example min max mean stderr lclm uclm;
  by x;
  var y;
run;

Note that for X=2 the STDERR is 0 because all of the values of Y are the same for that value of X.

 

Likely that means for one or more values of your variable TRTN your dependent variable has the same values, i.e. all of them imputed(possibly) to the same value, or before your imputation no values were missing, all the same and none imputed.

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1 reply
  • 1055 views
  • 1 like
  • 2 in conversation