topic Including Missing Values in Analyis in SAS Procedures

Including Missing Values in Analyis

deleted_user — Thu, 22 Jul 2010 14:56:18 GMT

If I want to include missing value category in proc phreg procedure. how do I do it?
Specifically, I have 3 levels of income: 1, 2 amd 99 (unknown). How do I set 99 to missing yet include it in analysis so that I would not lose other observations?

Thanks very much! Message was edited by: natasha85

Re: Including Missing Values in Analyis

Doc_Duke — Thu, 22 Jul 2010 17:43:35 GMT

Rather sounds like you want to treat it as missing some times and not others. That calls for multiple variables.

There are a several approaches to attack the problem. 1) and 2) model the effect of missing explicitly and are reasonable when there is moderate missing data so the model has enough power. It is particularly valuable if the missingness is not at random. 3) applies different principles and is much more useful when the presence of missing is more of a nuisance.

1) Leave it as 3 levels and treat it as a class variable.
2) Equivalently, and I find this to be more interpretable.
-- create a new variable IncomeMiss that is coded 0/1, with the 1 as missing and 0 otherwise.
-- recode income to 0/1 with the level of interest being the 1, and 0 otherwise.
-- put both variables in the model as continuous.
Then the effect of Income level 1 is measured by the coefficient for income and the effect of missing income is captured in the other variable.
3) Apply PROC MI and MIANALYZE.

Doc Muhlbaier
Duke

Re: Including Missing Values in Analyis

ArtC — Thu, 22 Jul 2010 17:57:50 GMT

If income is a classification variable, you can specify the MISSING option on the CLASS statement. Missing levels of the classification variable will be included in the analysis.

Re: Including Missing Values in Analyis

deleted_user — Thu, 22 Jul 2010 22:25:49 GMT

Thank you all!