turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- MI Percents

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-24-2015 09:23 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-26-2015 12:56 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-26-2015 04:39 PM

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;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-26-2015 04:58 PM

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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-26-2015 05:18 PM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-29-2015 08:56 AM

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