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.

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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
  • 930 views
  • 1 like
  • 2 in conversation