topic Re: SAS: Obtain Counts and Percentages for Categorical Variables from Imputed Data in SAS Procedures

PROC MIANALYZE: Counts and Percentages for Categorical Variables from Imputed Data

dee1214 — Fri, 24 Apr 2020 17:49:32 GMT

For my analysis, I have used PROC MI to produce 10 imputed datasets. I am trying to create a participant characteristics table using the imputed datasets. For continuous variables, I was able to use PROC UNIVARIATE and then PROC MIANALYZE to get means and standard deviations. For categorical variables, I was not able to use PROC FREQ and PROC MIANALYZE to get counts and percentages. Here is the code that wrote:

proc freq data = imputed_data;
    table GENDER/ out = temp;
    by _IMPUTATION_;
run;

proc mianalyze data = temp;
    modeleffects Count Percent;
run;

Is there something that I am not doing correctly? Is there something else that I should try?

Re: SAS: Obtain Counts and Percentages for Categorical Variables from Imputed Data

ChrisNZ — Fri, 24 Apr 2020 04:44:24 GMT

You could change the title from

SAS: Obtain Counts and Percentages for Categorical Variables from Imputed Data

proc mianalyze: Counts and Percentages for Categorical Variables from Imputed Data

to increase your chances of being helped

Re: SAS: Obtain Counts and Percentages for Categorical Variables from Imputed Data

dee1214 — Fri, 24 Apr 2020 17:48:50 GMT

Thanks for that!

Re: SAS: Obtain Counts and Percentages for Categorical Variables from Imputed Data

ChrisNZ — Sun, 26 Apr 2020 01:00:32 GMT

Still no reply.

Moved to procedures forum.

Re: PROC MIANALYZE: Counts and Percentages for Categorical Variables from Imputed Data

Rick_SAS — Wed, 29 Apr 2020 15:28:43 GMT

Please show your PROC MI call.