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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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