BookmarkSubscribeRSS Feed
raj00728
Fluorite | Level 6

Hi,

 

I am new to PROC MI. I have 500 unique patient data with 30 variables, of which 15 variables have missing values. Using multiple imputations procedure, I was able to impute 15 different variables (some binary, some ordinal and a few nominal); 30 imputations in total. So my final data set contains 15000 observations. Then I created a few summary variables from the "new imputed variables" to be used as covariates in the regression models. Now, I am unable to conduct univariate, bivariate and multivariate analyses using standard SAS procedures and then combining them using PROC MIANALYZE. I want to do something like the following using the multiple imputed data set (30 imputations):

 

1. I want to have standard table 1 to describe my sample. I want to report: n (%) for categorical variables and mean (SD) for continuous. 

2. I want to have standard table 2 to describe my sample by my exposure (2 level) and conduct a Chi-square for categorical variables and t-test for continuous.

3. I want to have standard table 3 which compares adjusted LS Means and SE for my continuous OUTCOME variable across the exposure, adjusting for several covariates. 

 

Could someone please guide me? Thanks.

 

-Raj

 

 

6 REPLIES 6
Brad19
Calcite | Level 5

Hey, 

Did you figured out pooling frequency and means (SD) after imputation?

 

Brad.

Rick_SAS
SAS Super FREQ

The best way to get a quality response is to post sample data, the SAS code you are using (even if it is wrong), and an explanation of what you are trying to accomplish.  Even if you don't know enough to write code, you can describe the problem and someone can point you to documentation and examples.

Brad19
Calcite | Level 5
I think it does not require to send you the codes or dataset. One who has done it write the syntax to ease others using SAS community.
ChuksManuel
Pyrite | Level 9
Hello Brad,

Did you make a find a syntax for pooling imputed datasets?
ChuksManuel
Pyrite | Level 9

Hello,

Did you finally succeed in  pooling your imputed dataset through sas? It seems SPSS has an easy syntax to pool imputed dataset according to Rubin's rule but i can't find any syntax for this in SAS.

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 16. 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
  • 6 replies
  • 3142 views
  • 2 likes
  • 4 in conversation