Programming the statistical procedures from SAS

MI Percents

Reply
Frequent Contributor
Frequent Contributor
Posts: 109

MI Percents

Hello,

I have run Proc MI, in particular the FCS Discrim for arbitrary missing categorical data. I had one categorical variable with missingness, we will call it X1.  I imputed it and got the  category percentages for X1. I also used the imputes in the BY statement of a Proc Freq and got a chi-sq test statistic, pooled them for the X1 imputes. In the chi-sq test, I compared X1 to another categorical variable (without missingness), we  will call this X2.

My question, is it possible to get the imputed values (percentages) of X1for the X2 variable levels? The program just kicks out the percentages for X1, though I was hoping to see the percentages for X1 at the unique groups of X2. You can see the unique values in the impute, but these are the ungrouped or unpooled versions.

Let me know if I need to clarify anything!

Thanks,

H L

Respected Advisor
Posts: 2,655

Re: MI Percents

I must be missing something here, because I would think that

proc freq;

tables X2*X1;

run;

would give the row, column and cell percentages, from which you could get everything I see in the question.

Steve Denham

Frequent Contributor
Frequent Contributor
Posts: 109

Re: MI Percents

That would not give me the pooled values for X1 at each level of X2 (since I used the "by impute", it gives me  100 of them). However, you got me to go back and look at the code and a comparable adjustment  did work!! I could insert it further up in the code:

proc surveyfreq data=yourdata_imp;

     tables X1*X2 / row nofreq nototal;

     by _imputation_;

     ods output onway=yourdata_freq;

run;

Frequent Contributor
Frequent Contributor
Posts: 109

Re: MI Percents

No I take it back that did not work. I did not examine the output carefully enough, it still gave me 100 versions.

I need to figure out a way to keep the X2 variable in the onway dataset or the formula to pool the values!

Frequent Contributor
Frequent Contributor
Posts: 109

Re: MI Percents

Figure 4 in the attached article makes it seem like the values I am searching for would just be the averages.

So I am looking at the pooled estimates part, but instead of a coefficient, I just have a percentage value.

Sorry, I can ever cut-n-paste on the webpage, the paper is titled:

principled missing data methods for researcher, it is available full text on pubmed.

Respected Advisor
Posts: 2,655

Re: MI Percents

I figured I misunderstood.  Do you want the percentage of values that were imputed for X1 for each level of X2?  If so, then create a flag in the imputed dataset for X1_missing, and then do tables X2*flag.

I am afraid I am still missing something here.

Steve Denham

Ask a Question
Discussion stats
  • 5 replies
  • 363 views
  • 1 like
  • 2 in conversation